Microsoft KB Archive/291314

= XL2002: How to Make Print Titles Appear on Every Page of Output =

Q291314

-

The information in this article applies to:


 * Microsoft Excel 2002
 * Microsoft Visual Basic for Applications

-

For a Microsoft Excel 2000 version of this article, see Q214022.

For a Microsoft Excel 98 version of this article, see Q192283.

For a Microsoft Excel 97 and earlier version of this article, see Q117799.

SUMMARY
In Microsoft Excel 2002, 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: This behavior is different from versions of Excel earlier than Excel 97. In earlier versions, 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, position those titles in the leftmost columns of your print area.

Example
To see an example of this behavior, follow these steps:
 * 1) Create a new workbook.
 * 2) In cells A1 through A11 of Sheet1, type the following data:
 * 3) Click the row heading for row 8, and then click Page Break on the Insert menu.
 * 4) On the File menu, click Page Setup, and then click the Sheet tab.
 * 5) In the Rows to repeat at top box, type $5:$5, and then click Print Preview.

NOTE: The title, &quot;Food,&quot; 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 Excel, the title &quot;Food&quot; appears at the top of every page.