How to Reduce Excel File Size
Follow these 4 steps to reduce the size of your file and speed up Excel response time.
There are some simple things you can do to reduce the size of a large Excel file and speed up operation. Below are some quick and easy steps to reduce Excel file size. (Note, before you begin, it’s a good idea to have a backup of your file just in case something goes wrong).
- Select the first blank column, hold down Ctrl + Shift and push the right arrow (this will highlight all columns). Then, right click and select delete. Do the same for rows; go to the first row after your data, select it, hold down Ctrl + Shift and push the down arrow. Right-click and delete.
- You can also use the Go to Special Function. Press F5 > Special, then select “Blanks”; after all blanks are selected select “Clear All” from the Editing tool bar under the Home Ribbon.
- Set your Excel Options so that workbook calculation is manual. File > Excel Options > Formulas > Manual.
- Review your formulas to ensure you don’t have a lot of unnecessary formulas, or formulas that are considered volatile (i.e., always recalculated, even when precedents remain unchanged). Volatile functions are Randbetween( ), Today ( ), Offset ( ), Index ( ), Info ( ) etc.
There you go…4 steps on how to reduce excel file size. Let us know if this helped. Any other tips?