Microsoft KB Archive/72542

{| = Using Multiple Fonts in Headers and/or Footers in Excel =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q72542

SUMMARY
If you use alignment codes in a header or footer, you must also apply the desired font to each aligned segment. Each segment defaults to the normal font unless otherwise specified. This includes fonts, font sizes, or styles (bold, italic, etc.).

Example
The goal is to display the current time in the bottom left corner of the page, the name of the worksheet in the bottom center and the date in the bottom right. All three segments should be formatted using Helvetica 15.

 From the File menu, choose Page Setup.  In the Footer box, type the following: &L&&quot;HELV&quot;&15&T&C&&quot;HELV&quot;&15&F&R&&quot;HELV&quot;&15&D (Note that you could also specify a different font for each segment, if desired. Also, the font should match the font name located under the Fonts option of the Format menu and should be in quotation marks.)  Choose OK. From the File menu, choose Print Preview to view the footer.