Microsoft KB Archive/100840

= Microsoft Knowledge Base =

Excel: Headers/Footers Are Printed in Incorrect Font
Last reviewed: September 12, 1996

Article ID: Q100840

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
 * Microsoft Excel for OS/2, version 3.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0

SUMMARY
In Microsoft Excel, when you use an ampersand (&) control character to specify a font name in a header or footer, if you use a null string instead of specifying a font name (for example, &""), the resulting font is Terminal in Microsoft Excel for Windows or OS/2, or Geneva in Microsoft Excel for the Macintosh regardless of the font defined for the normal style.

This behavior occurs regardless of point size or formatting options you select (bold, italic, and so on).

Workaround
To work around this problem, remove the &"" preceding the text in your header or footer. The text will be printed in the Normal style font.

MORE INFORMATION
In Microsoft Excel, the default font for the header or footer is based on the Normal style font. To change the font of the header or footer, you can use an ampersand control character followed by the name of the desired font enclosed in quotation marks (for example, &"Times New Roman").