Microsoft KB Archive/58221

{| = Excel: Header/Footer Text Overlaps When Printed/Page Preview =
 * width="100%"|

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 &quot;Corporation of San Francisco&quot; overlapping &quot;Monthly Report for S&quot;, because the second &quot;&L&quot; is aligning &quot;Corporation of San Francisco&quot; 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 &quot;Microsoft Excel Reference&quot; manual for version 2.20.
 * }