How do i reduce the size of an Excel file ?
Size of the Excel file is mostly reduce by clearing borders that are applied to all the rows of the spreadsheet. Follow following steps to clear the borders
Step I - Press Ctrl+End to get to the last row of the data in the spreadsheet.
Step II - Move down one row.
Step III - Hold the <Shift> and <Ctrl> key, press the right arrow key once, then the down arrow.
Step IV - Select Edit>Clear>Formatting.
Older news items:
- 21/09/2010 05:49 - How do i find my PC name, PC uptime, product ID, processor ?
- 31/12/2009 02:51 - How do i delete cookies from all the web browser ?
- 23/12/2009 23:46 - What files are not sent to Windows Recylce Bin ?
- 18/12/2009 04:12 - How do I Password Protect my Internet Explorer ?
- 09/12/2009 02:17 - How do i change drive letter of a USB stick, CD ROM, and other disc drives ?
- 10/11/2009 04:04 - How Do I Password Protect My Files and Folders in Windows?
Last Updated (Tuesday, 19 April 2011 05:02)
Back




