7 Tips to keep Excel File Size Small

Structure of an Excel file is designed that consumes low memory space on drives. But sometimes contents file can enlarge size of file. More often you may have noticed delay while Loading a simple file or during normal Calculation. It seems frustrating but we can take precautions to avoid such delay by keeping the Excel file size optimized.

Smaller size of any excel file is very important for portability and fast access.
Here are some tips to keep or reduce file size using Excel 2007.

1. If excel file contains any image. Right click on the image and click compress or from the formatting tab click on Compress Picture (can be found in top left corner).
Uncheck "Apply to selected picture only".

Because images takes most of the space in any file reducing that can help to reduce excel file size up to 75%

2. Don't format your worksheet more than needed. Sometimes we select the entire row or column or sheet and select Fill color or Borders. This also increases the size of worksheet.
If you are using conditional formatting it also takes more time during opening an excel file. Remove the conditional formatting if it is not required.

Home - Conditional Formatting - Clear Rules - Clear Rules from Entire Sheet

Repeat above step on all the sheets.

3. Use paste special to convert formulas into Values so that it can be converted in values and reduce the size of file and also the loading time will be reduced but still recommended not to convert all the formulas as values, but recommended to convert all external links in to values so that your values will remain intact to the person you are emailing this file or if external link is not found.

4. If you have shared that workbook for multiple users then remove the sharing.

5. BEWARE Excel files might contain some viruses disable macros before opening (Macro - Macro Security - and select High security) until you are very sure that the macro contained in the excel file are safe don't enable it.

6. If your file contains simple data and still its size is huge try to copy all the data into another file and then save the file as another name.

7. One of the most ignored action in Excel files especially in 2007 or later versions that at the end of Column or Row we write something accidently and then we simply delete it. Excel treats the last most cell on which data entry is done as the end of the sheet.

To check this Press Ctrl + End and see the last most cell. If it is bottom or end of the row select the unnecessary Rows or Columns and from Select Home - Clear - Clear All.

This will help to reduce the size of the file.