Microsoft KB Archive/58221

From BetaArchive Wiki

Excel: Header/Footer Text Overlaps When Printed/Page Preview

Last reviewed: November 4, 1994
Article ID: Q58221

The information in this article applies to:

  • Excel for the Macintosh, versions 1.0, 1.5 and 2.2


If text in a header or footer overlaps when printed (or when viewed in Print Preview), it could be caused by positioning commands. The commands &L, &C, and &R all position text in a header or footer. If text in a header and/or footer contains an ampersand (&), it might be interpreted as a formatting command.

For example, using the following as footer information

   &L Monthly Report for S&L Corporation of San Francisco

results in "Corporation of San Francisco" overlapping "Monthly Report for S", because the second "&L" is aligning "Corporation of San Francisco" to the left. When an & is desired in a header or footer, use && instead of &. For the above example to print correctly, use the following text:

   &L Monthly Report for S&&L Corporation of San Francisco

For a full listing of all the & commands, see page 268 of the "Microsoft Excel Reference" manual for version 2.20.

KBCategory: kbprint


Additional reference words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20

Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.