Microsoft KB Archive/214368

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

PSS ID Number: 214368

Article Last Modified on 10/27/2002

-

The information in this article applies to:


 * Microsoft Excel 2000

-



This article was previously published under Q214368



For a Microsoft Excel 2002 version of this article, see 299033.

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 step-by-step article describes how to change the default font or font size in Microsoft Excel 2000. The default font that is used by Excel 2000 is 10-point Arial. To override the default font or font size in Excel, use either of the two methods 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 and Size boxes, 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 that are used by earlier versions of Excel are listed in the following table.                                                          Default Version of Microsoft Excel            Default font    font size

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

Microsoft Excel 98 Macintosh Edition  Geneva           9 5.0, 5.0a for the Macintosh           Geneva          10 Earlier versions for the Macintosh    Geneva          10 When you open a workbook that is created in one version of Excel in another version of Excel, a workbook may look different from a new workbook that you create. This is because of the differences in default font and font size.

This behavior is especially noticeable in Microsoft Excel 98 Macintosh Edition, which uses a different default font size from other versions of Excel.

back to the top

