logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

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/

Starting this utility

In the Excel menu choose: ASAP Utilities » Format » Remove all unused styles on every sheet

« Return to the list of “Format” tools.
«
Clean data and formatting...
 
  »
Remove all validations in selected cells
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
Colour, colours

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook