G Guest Jun 26, 2007 #1 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.)
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 Jun 27, 2007 #2 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 (e-mail address removed) web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/
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 (e-mail address removed) web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/
L Luke Dec 3, 2008 #3 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?
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?