Clear Excess Formatting
This tool does two things:
|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.