Page 301 - Excel 2013 All-in-One For Dummies

Working with the Page Setup Options 283
Note that Excel indicates the print-title columns in the worksheet by placing a dotted line (that moves like a marquee) on the border between the titles and the information in the body of the report.
3. Click OK or press Enter to close the Page Setup dialog box or click the Print Preview button to preview the page titles in the Print Preview pane on the Print screen.
After you close the Page Setup dialog box, the dotted line showing the border of the row and/or column titles disappears from the worksheet.
Figure 5-8:
Specify the rows and columns to use as print titles on the Sheet tab
of the Page Setup dialog box.
In Figure 5-8, rows 1 and 2 containing the worksheet title and column head- ings for the Income Analysis worksheet are designated as the print titles
for the report. In Figure 5-9, you can see the Print Preview window with the second page of the report. Note how these print titles appear on all pages of the report.
To clear print titles from a report if you no longer need them, open the Sheet tab of the Page Setup dialog box and then delete the row and column ranges from the Rows to Repeat at Top and the Columns to Repeat at Left text boxes before you click OK or press Enter.
Book II Chapter 5
Printing Worksheets