Excel Error Message - Too Many Fonts
Posted on 2009-04-04
I apparently have a bloated workbook. Painfully slow inserting rows/columns.
Frequent error message "too any fonts on this sheet..."
After several dozen clicks it disappears.
I tried selecting the entire sheet and a one font. That does not seem to help.
I have changed the default font in the tools/options menu from arial to calibri, which i would now like to use in all workbooks. Even with the default changed, arial shows up when creating new worksheets or starting new workbooks most of time.
1. How do i get rid of the error message?
2. How to I teach excel to use the default font specified in the tools/options screen?
3. Would it help if I cleaned out the huge selection of fonts in windows?