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."
Source...