Reducing size of Microsoft Excel file automatically

Reducing the size of Microsoft Excel file automatically

Here is a quick tip on reducing the size of Microsoft Excel file quickly and easily. You may need to reduce it for any number of reasons, and this is a quick way to get that done.

  • Launch Microsoft Excel or the Microsoft Workbook in question
  • Go to Files -> Options -> Add Ins
  • In the “Manage” drop-down box, select “COMS Add-ins” and click Go.  Select the “Inquire” option.
  • This creates an “Inquire” tab in your Excel workbook.
  • Under “Inquire”, select the feature “Clean Excess Cell Formatting”.

 This process will clean all the "white noise" which builds up especially in those workbooks that have had a lot of changes to them.