Guides
Fix "Too Many Different Cell Formats" in Excel: Causes and Cleanup
Updated 2026-10-13
You try to format a cell, insert a row or paste, and Excel stops you with "Too many different cell formats." From then on, many edits fail. The problem isn't the amount of data: the workbook has hit the limit on format combinations.
What the limit is
Excel counts every unique combination of font, border, fill, number format, alignment and cell protection as one format. If two cells differ in any one of these, they use two formats.
Microsoft's "Excel specifications and limits" page puts the maximum number of unique cell formats and cell styles per workbook at about 65,000 (the current page says 65,490; older documentation says 64,000, and Excel 2003 allowed about 4,000).
Why formats pile up
- Copying between workbooks. Microsoft notes that copying from another workbook brings its custom cell styles along. A report copied back and forth a few times can collect tens of thousands of styles.
- Reports assembled from many sources. Each source brings its own set of formats.
- Files exported by other software. Some programs write a separate format for every cell, even when they look identical.
- Ad-hoc formatting. Every slightly different font size, color or border is a new combination.
How to confirm it
- Home > Cell Styles shows a long list of custom styles you never created.
- Copy the file, rename it from
.xlsx to .zip and open it: xl/styles.xml is unusually large, several megabytes or more.
Clean it up by hand
- Clear formatting from empty areas. Select the rows and columns outside your data and choose Home > Clear > Clear Formats.
- Delete unused custom styles. Right-click each one under Home > Cell Styles and delete it. With thousands of styles this is not realistic.
- Standardize formatting. Use cell styles or Format as Table instead of one-off formatting.
- The thorough option: start a new workbook. Paste only values into a new file (Paste Special > Values) and reapply the formatting you need. You lose the formatting and have to rebuild formulas separately.
Some Office editions include the Inquire add-in, whose Clean Excess Cell Formatting command clears formatting from empty areas, but it doesn't merge duplicate styles.
One click: slim it with xlszip
xlszip merges duplicate fonts, fills, borders and cell formats, drops format records and custom number formats that no cell uses, and clears formatting from empty rows and columns. Formats that look the same become one, so the sheet looks exactly as before; afterwards every cell's value, formula and format is compared with the original. Named styles in the Cell Styles gallery are kept as they are; delete the ones you don't need as in step 2.
If a workbook genuinely contains tens of thousands of different formats, merging duplicates can't bring the count down, and steps 3 and 4 above are the way out. Not sure which case you have? Run a check-up to see how much style bloat there is.