Defining Default Fonts Using Styles in Excel

ID: Q68637

SUMMARY

Microsoft Excel version 3.00 worksheets can have up to 256 fonts defined per sheet. Many users have relied on the "font list" 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:

Enter Font1 in the Style Name: box.

Press the Font button.

Select Helv size 10 and press OK.

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.

REFERENCES

"Microsoft Excel User's Guide." Pages 206, 555.

Additional query words:

Keywords :
Version :
Platform :
Issue type :