Help Menu

Clear Excess Formatting

This tool does two things:

  1. First, it runs the Reset Used Range tool.
  2. Then, it clears all the formatting in cells that extend beyond the used range.

For example, if you have selected Row 1 and set the font to bold for headings, you could easily have thousands of unused cells with the font set to bold. This tool will clear the formatting from those unused cells, reducing the size of the Excel file.