Defining Default Fonts Using Styles in Excel

 Last reviewed: October 18, 1994
Article 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:

  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.

REFERENCES

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

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 18, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.