Microsoft KB Archive/299033

= HOW TO: Change Default Font and Font Size in Excel 2002 =

PSS ID Number: 299033

Article Last Modified on 11/25/2002

-

The information in this article applies to:


 * Microsoft Excel 2002

-



This article was previously published under Q299033



For a Microsoft Excel 2000 version of this article, see 214368.

For a Microsoft Excel 98 and earlier version of this article, see 175684.

IN THIS TASK

 * SUMMARY
 * ** Method 1: Set the Font Size and Font in the Options Dialog Box
 * Method 2: Create a Template
 * Default Fonts in Earlier Versions
 * REFERENCES



SUMMARY
This article describes how to change the default font or font size in Excel 2002. The default font that Excel 2002 uses is 10 point Arial. You can override the default font or font size in Excel by using either of the methods that are described in this article.

back to the top

Method 1: Set the Font Size and Font in the Options Dialog Box
To do this, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) Click the General tab.
 * 3) In the Standard font box and the Size box, select the font and size that you want to use.
 * 4) Click OK.

back to the top

Method 2: Create a Template
You can also override the default font and font size by creating a template with a style that is formatted with the font and font size that you want. When you create a new workbook by using the template, the new workbook uses the same formatting as the template.

back to the top

Default Fonts in Earlier Versions
The default fonts and font sizes used by earlier versions of Excel are listed in the following table.                                                          Default Version of Microsoft Excel            Default font    font size

Microsoft Excel 2000                  Arial           10 Microsoft Excel 97                    Arial           10 7.0, 7.0a for Windows                 Arial           10 5.0, 5.0c for Windows                 Arial           10 Earlier versions for Windows          MS Sans Serif   10 Because of the differences in default font and font size, when you open a workbook that is created in one version of Excel in another version of Excel, the workbook may appear different from a new workbook that you create.

back to the top

