XL98: Left/Right-Aligned Header/Footer Text Ignores Margins (192218)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q192218 SYMPTOMS
When you print your worksheet, headers and footers that you have applied to
the worksheet may print outside of the margins that you have set for the
worksheet.
CAUSE
In Microsoft Excel, the header and footer on your worksheet always use a
left and right margin of 0.75 inch. Because of this, left-aligned text in
the header or footer always begins 0.75 inches from the left edge of the
page, regardless of the left margin setting. Similarly, right-aligned text
will always print 0.75 inches from the right side of the page.
WORKAROUND
Although you cannot change these margins, you can create wider margins by
adding extra spaces to the header or footer ("padding").
To pad the left header or footer, you can add spaces before the text.
However, because the right header or footer ignores trailing spaces, you
must use a nonbreaking space to allow the spaces to be maintained when you
add them to the end of your footer.
To pad the right header or footer with spaces, follow these steps:
- On the File menu, click Page Setup.
- Click the Header/Footer tab, and then click Custom Header or Custom
Footer.
- In the Right Section box, type the text or control codes that you want
to appear in the header.
- Press OPTION+SHIFT+SPACEBAR to enter nonbreaking spaces (press this key
combination as many times as necessary to insert the number of
spaces you want).
The spaces at the end of the text string are applied to the printed output.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb kbprint KB192218 |
|---|
|