Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Assigning a Macro to a Keyboard Combination

Creating Scenarios

Using Message Boxes

Understanding Phantom Macros

Picking a Group of Cells

Running Out of Memory

Hiding Rows Based on a Cell Value

 

Simplifying the Font List

Summary: Excel normally displays the font list on the toolbar or using the very fonts it is displaying. Here's how to change that behavior in some versions of Excel. (This tip works with Microsoft Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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.

Whether you can turn this capability off or not depends on the version of Excel you are using. If you are using a version of Excel prior to Excel 2007, the program provides a control that turns the feature on or off. If you are using Excel 2007 the control has been removed; you cannot simplify the font list and it must be displayed using the actual fonts.

To turn this feature off in Excel 2000, Excel 2002, or Excel 2003, follow these steps:

  1. Select Customize from the Tools menu. Excel displays the Customize dialog box.
  2. Make sure the Options tab is displayed. (Click here to see a related figure.)
  3. Clear the List Font Names In Their Font check box.
  4. Click Close.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2832) applies to Microsoft Excel versions: 2000 | 2002 | 2003 | 2007

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.
 
Check out PivotTables for the Faint of Heart today!