by Allen Wyatt
(last updated May 15, 2017)
When you click the Font drop-down list on the Formatting toolbar, Excel shows you the names of all the fonts you can use to format whatever you have selected on the screen. Normally, Excel shows the font names using the actual font. You may find the differing font faces to be distracting, or your slower computer may be really slow when listing all the fonts.
Here's how you turn this capability on and off in Excel 2000, Excel 2002, and Excel 2003:
Figure 1. The Options tab of the Customize dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2832) applies to Microsoft Excel 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
If your Formula bar disappears when you load a workbook, it could be due to the presence of a macro that turns it off. This ...Discover More
Once you've edited your toolbars, you may want to change them back to their default appearance and behavior. This tip ...Discover More
Toolbars don't need to be tethered to the top of your program window. Although they are right at home there, you may want ...Discover More