The information in this article applies to:
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.
MORE INFORMATIONTo 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. ExampleTo see an example of this behavior, follow these steps:
REFERENCESExcel 97For 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: Q120802 Office: How to Add/Remove a Single Office Program or Component Excel 5.0For more information about Print Titles, click the Search button in Help and type:Print Titles Additional query words: 5.00c 97 XL97 XL7 XL5
Keywords : kbprint kbdta |
Last Reviewed: October 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |