How to Reduce the Size of an Excel Spreadsheet

Excel spreadsheets perform a lot of data manipulation and calculations, and they can progress to fairly large file sizes, often for reasons that seem inexplicable. Excel file sizes go up with the total number of cells in use, so most techniques for file size reduction are geared toward eliminating unused cells. Reducing file sizes can dramatically improve performance for large spreadsheets, and can make them easier to send as attachments.

Make a backup copy of the file you want to reduce.

Open the Excel document and hit "Ctrl" + " End" in each tab of the spreadsheet. You're looking for the last cell with data in it, in effect the lowest, right-most cell in the worksheet. For many sheets, this cell will be well outside of what you might have thought the spreadsheet contained.

Select unused columns by clicking on a column header, then holding down the "Ctrl" + "Shift" + "Right Arrow" keys. This will select all columns to the right of the one you selected, including the one you selected. Press the "Delete" key.

Select unused rows by clicking on a row header, then holding down the "Ctrl" + "Shift" + "Down Arrow" keys. This will select all rows beneath of the one you selected, including the one you selected. Press the "Delete" key.

Most recent