"Too many formats used"!!!

D

David Forbes

I have a large spreadsheet with multiple input forms which is almost complete. I am unable to progress further as Excel will not allow me to format any more cells with a "Too many formats used" message being displayed

I understand that I need to reduce the amount of formatting that has been used, but my endeavours to do so simply pops up the same message.

Is there a simple way to reduce the number of formats used in a spreadsheet either globally or per worksheet? Or any other solutions to this problem

Any help would be greatfully appreciated.
 
Top