Microsoft KB Archive/68637

= Defining Default Fonts Using Styles in Excel =

PSS ID Number: 68637

Article Last Modified on 7/30/2001



This article was previously published under Q68637



SUMMARY
Microsoft Excel version 3.00 worksheets can have up to 256 fonts defined per sheet. Many users have relied on the &quot;font list&quot; on the Format Font dialog to keep track of commonly used font styles.

This functionality has been updated through the use of styles that are accessible from the tool bar. This makes defining and using font styles very easy. You can define a style for the font you want to use often, select the cell, and choose the style from the tool bar.

Styles are saved with the worksheet and aren't global. Templates can be used to make styles available to new worksheets. By defining or changing a style on the template, all new worksheets will have this modified style available.



MORE INFORMATION
Excel 2.x allows you to define the four fonts you use most often and put these on a menu. Excel 3.0 also provides this feature, using styles. The four default fonts in Excel 2.x are:

  Font 1 = Helvetica 10 Font 2 = Helvetica 10 Bold Font 3 = Helvetica 10 Italic Font 4 = Helvetica 10 Bold Italic

To define styles for these fonts, choose Styles from the Format menu and press the Define button. This dialog allows you to define a style name and all of the attributes that you like.

Do the following to make the Font1 style available:


 * 1) Enter Font1 in the Style Name: box.
 * 2) Press the Font button.
 * 3) Select Helv size 10 and press OK.
 * 4) Select Add.

This same procedure can be used for the other fonts listed above. These can now be used by simply selecting the cells and choosing the style from the tool bar.

