Header or Footer Prints in the Font from Normal Style

Last reviewed: November 4, 1994
Article ID: Q69721

The information in this article applies to:

Microsoft Excel for Windows, version 3.0, 4.0, 4.0a, 5.00

SUMMARY

In Microsoft Excel, if you print a document and the font for the header or footer appears different than the rest of the document, it is possible that the cells from the worksheet are formatted with a different font and/or font size than the Normal style.

There are two ways to correct this:

Choose Style from the Format menu and change the Normal style to the font and font size you want to have applied to the entire document.
-or-
Format the text in the header or footer by using the following steps:
Microsoft Excel version 5.0 ---------------------------
1. From the File menu, choose Page Setup.
2. Select the Header/Footer tab, and choose the Custom Header or Custom
```
      Footer button.
```
3. Select the text in the header or footer that you want to format, and
```
      choose the Font button (A) to format the font.
```
Microsoft Excel versions 3.0 and 4.0 ------------------------------------
1. From the File menu, choose Page Setup.
2. Enter the font you want to use in the header or footer line,
```
      surrounded by quotation marks and preceded by an ampersand (&). To
      change the font size, place an ampersand followed by the size you
      want to use. The following sample header
```
```
         &18&"Courier"This is the Header

      will print

         This is the Header

      in the Courier font, 18 point font size.
```

Using either method should allow you to print the header and footer in whichever font you choose.

MORE INFORMATION

The formatting of the header and footer is controlled by the Normal style for the worksheet. You can override the Normal style, however, by using the Custom Header button and formatting the text (version 5.0 only) or by hard coding the font into the Header or Footer line in the Page Setup dialog box.

Highlighting the entire worksheet and changing the font is not the same as changing the Normal style. You must choose Style from the Format menu to change the Normal style.

Additionally, any other changes you make to the Normal style are applied to the entire document, including the header and footer.

REFERENCES

"Microsoft Excel User's Guide," version 3.00, page 212-213 and 534-535

KBCategory: kbprint
KBSubcategory:
Additional reference words: 3.0 3.00 4.0 4.00 4.0a 4.00a 5.00

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: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.