Friday, August 24, 2012

How to Reduce the Size of a Large Excel 2007 File


1. Press 'Ctrl' and 'End' at the same time. This will bring you to the bottom right cell of the worksheet.
2. Select all the rows between your real last used row, and the row that Ctrl End brought you to. To select a row, click on the row identifier (for example, 'A.'). To select multiple rows, hold down the 'Shift' key and click the first and last row. Press 'Delete.'
3. Select all the columns between your real last used column, and the column that Ctrl End brought you to. Press 'Delete.'

Blogger news