Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My company uses very large spreadsheets
to confrom to goverment requirements. Recently we have run into a Warning message when we try to insert a new column. It says we've used up all the cell formats, so we can't add any new cells. The Microsoft documentation seems to indicate that the maximum number of cell formats is 4000. I guess we're hitting that limit and Excel won't let us enter anymore data. How do I increase the max number of cell formats? How do I find out how many I've used already? How do I delete ones I'm not using (Excel seems to "hang on" to all the cell formats we've ever generated)? Thanks. Jim Allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
how can i multiply a number in each cell? | Excel Discussion (Misc queries) | |||
How to add the number in cell one by one in Hex format | Excel Discussion (Misc queries) |