Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100840

From BetaArchive Wiki

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").

REFERENCES

"User's Guide 1," version 4.0, page 535 "User's Guide," version 3.0, pages 534-535


KBCategory: kbprint

KBSubcategory:

Additional reference words: 3.00 4.00 4.00a error missing



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: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.