Too many different cell formats

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.
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'too many different cell fomats' 2
Too Many Cell Formats Error 3
How do you correct "too many different cell formats", message. 1
Too many different cell formats error message in Excel 3
getting message "too many differant cell formats" can't add lines 1
How fix error message "too many different cell formats"? 1
How do i correct the " too many different cell formats"? 1
too many different cell formats 1

Top