XL98: Extra Columns or Rows Are Included in Print Titles When You Include Merged Cells (179006)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q179006 SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, when you create print titles on a
worksheet, additional columns or rows that are not selected may be added to
the print titles.
CAUSE
This behavior may occur when you use the mouse pointer to select columns or
rows for print titles, and the selected columns or rows contain merged
cells that extend into other columns or rows.
WORKAROUND
To work around this problem, type a range for print titles in the Sheet tab
of the Page Setup dialog box instead of selecting the range with the
pointer. To do this, follow these steps:
- On the File menu, click Page Setup.
- Click the Sheet tab.
- In the appropriate box ("Rows to repeat at top" or "Columns to repeat at
left"), type the range that you want to use for print titles. Do not
select the range with the mouse pointer.
For example, if you want column A to be repeated at the left edge of
each printed page, type the following text in the "Columns to repeat at
left" box:
If you want rows 1 through 3 to be repeated at the top of every printed
page, type the following text in the "Rows to repeat at top" box:
4. Click OK.
STATUS
This behavior is by design of Microsoft Excel 98 Macintosh Edition.
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbprb kbprint kbui KB179006 |
---|
|