XL98: Print Titles Do Not Appear on Every Page of Output
ID: Q192283
|
The information in this article applies to:
-
Microsoft Excel 98 Macintosh Edition
SUMMARY
In Microsoft Excel, print titles are printed only after the rows or columns
containing them are printed. For example, if you select a row or column on
the second page of a worksheet to be a print title, the titles are printed
only on the third and subsequent pages.
Note that this behavior is different from Microsoft Excel 4.0 and earlier.
In earlier versions of Microsoft Excel, print titles appear on every page
of the printed output regardless of their location on the worksheet.
MORE INFORMATION
To have a print title appear at the top of every page, position the rows
that contain your print titles in the uppermost rows of your print area.
Likewise, to have a print title appear at the left of every page, you
should have those titles as the leftmost columns of your print area.
Example
To see an example of this behavior, follow these steps:
- Create a new workbook.
- In cells A1 through A11 of Sheet1, enter the following data:
A1: Apples
A2: Bananas
A3: Carrots
A4: Eggplant
A5: Food
A6: Kudzu
A7: Melon
A8: Orange
A9: Peach
A10: Raspberry
A11: Zucchini
- Click the row heading for row 8, and click Page Break on the Insert
menu.
- On the File menu, click Page Setup. Select the Sheet tab.
- In the Rows To Repeat at Top box, type $5:$5. Then, click Print Preview.
Note that the title "Food" on row 8 appears only at the top of the second
page because it precedes the first row displayed on the second page in
print preview. In earlier versions of Microsoft Excel, the title "Food"
appears at the top of every page.
REFERENCES
For more information about print titles, click the Office Assistant, type
"print titles," click Search, and then click to view "Print row and column
headings on every page."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
Q179216 OFF98: How to Use the Microsoft Office Installer Program
Additional query words:
XL98
Keywords : kbprint kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto