Microsoft KB Archive/58221

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 SUMMARY 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 KBSubcategory: 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.