Header or Footer Prints in the Font from Normal Style
ID: Q69721
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 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
---------------------------
- From the File menu, choose Page Setup.
- Select the Header/Footer tab, and choose the Custom Header or Custom
Footer button.
- 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
------------------------------------
- From the File menu, choose Page Setup.
- 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
Additional query words:
3.0 4.0 4.00a
Keywords :
Version :
Platform :
Issue type :