XL: Print Titles Do Not Appear on Every Page of Output

ID: Q117799

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for Windows 95, versions 7.0, 7.0a

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 earlier versions of Microsoft Excel. 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:

1. Create a new workbook.

2. 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

3. Click the row heading for row 8, and click Page Break on the Insert

   menu.

4. On the File menu, click Page Setup. Click the Sheet tab.

5. In the "Rows to repeat at top" box, type "$5:$5" (without the quotation

   marks). 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

Excel 97

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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component

Excel 5.0

For more information about Print Titles, click the Search button in Help and type:

   Print Titles

Additional query words: 5.00 5.00c 7.00 97 XL97 XL7 XL5

Keywords          : kbprint kbdta
Version           : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.0,5.0a; WINNT:5.0
Platform          : MACINTOSH WINDOWS
Issue type        : kbhowto

Last Reviewed: January 7, 1999