Number of different cell formats

E

emilija

I have an excel file, which I can't opened because it has already too many
different cell formats, which I solved by formatting, but
is there a way how can I see a statistic of the number of formats used in
one file (out of 4000 I think), in order not to find my self in a same
situation in the future,
thanks in advance
 
P

Pete_UK

Excel must maintain a count somewhere in order to trigger this error,
but I don't think it is readily accessible.

The thing to do is to cut down on the number of different formats in
your workbook - don't go mad using lots of different type faces and
font sizes, borders and colours etc.

Hope this helps.

Pete
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Images are pixelated when saving to PDF 0
How to count number of different cell formats 2
Different Page Numbers or Number Formats for Different Sections 1
Editing conditional formats (Excel 2010) 15
Excel - Wich Function should I use? 1
Error: Too many different cell formats 2
Sorting Multiple Tables 1

Top