Too many different cell formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the hide formula function. But I keep getting the "Too
many different cell formats" error. I can't get past this and need help in
correcting the problem.
 
Marcor

The error is exactly what it says. Too many cell formats. Excel counts
cell formats as unique if anything is different, font, colour, alignment,
wrap, etc, etc. The limit is quite small too. To correct this I suggest you
set up a few styles, (format>styles...) and use these. That way you can be
sure that all formats that look the same, are.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top