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

• 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
• Microsoft Excel 97 for Windows
• 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 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. Select the Sheet tab.

5. In the Rows To Repeat at Top box, type "$5:$5" (without the quotation marks). Then, click Print Preview.

REFERENCES

For More Information about Print Titles, choose the Search button in Help and type:

   Print Titles