Error pop-up Message: Too many different cell formats

U

Uri

I can't understand why I get this message & how to get around it. (I do have
a lot of formatted cells in the sheet.)
 
N

Nick Hodge

Uri

A format is any change in combination of font, size, bold, colour, cell
fill, etc. It's easy to reach that number.

The only real way around is to set up some styles (Format>Styles...) and
apply these. This way you can be sure you are applying consistent styles

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 
L

Luke

Related question - is there any easy way to have Excel tell me how many
combinations there are and, if possible, give me a list of those specific
combinations?
 
Top