logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Remove all unused styles on every sheet

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Format  ›  Remove all unused styles on every sheet

This utility removes all unused styles from every worksheet in your workbook.
In most of the times this fixes the problems when you get the message "Too Many Different Cell Formats" in Excel.

What this message means is explained by Microsoft:
You receive a "Too many different cell formats" error message in Excel.
This problem occurs when the workbook contains more than approximately 4000 different combinations of cell formats. A combination is defined as a unique set of formatting elements that are applied to a cell. A combination includes all font formatting (for example: typeface, font size, italic, bold, and underline), borders (for example: location, weight, and color), cell patterns, number formatting, alignment, and cell protection.
Source: http://support.microsoft.com/kb/q213904/

Screenshots

Example screenshot: 1
1, Format  ›  Remove all unused styles on every sheet
Example screenshot: 2
2, Format  ›  Remove all unused styles on every sheet
Example screenshot: 3
3, Format  ›  Remove all unused styles on every sheet
Example screenshot: 4 Cleaning up a workbook with a huge amount of unused styles
4 Cleaning up a workbook with a huge amount of unused styles

Starting this tool


Download
Additional keywords for this tool:
Colour, colours
Clean data and formatting...



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us