Excel 2013’s Print Titles feature enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related data spill over to other pages that no longer show the row and column headings on the first page.
Don’t confuse print titles with the header of a report. Even though both are printed on each page, header information prints in the top margin of the report; print titles always appear in the body of the report — at the top, in the case of rows used as print titles, and on the left, in the case of columns.
To designate rows and/or columns as the print titles for a report, follow these steps:
Click the Print Titles button on the Page Layout tab on the Ribbon or press Alt+PI.
The Page Setup dialog box appears with the Sheet tab selected.
To designate worksheet rows as print titles, go to Step 2a. To designate worksheet columns as print titles, go to Step 2b.
Click in the Rows to Repeat at Top text box and then drag through the rows with information you want to appear at the top of each page in the worksheet below. If necessary, reduce the Page Setup dialog box to just the Rows to Repeat at Top text box by clicking the text box’s Collapse/Expand button.
Below, the Collapse/Expand button was clicked associated with the Rows to Repeat at Top text box and then dragged through rows 1 and 2 in column A of the Little Bo-Peep Pet Detectives – Client List worksheet. Excel entered the row range $1:$2 in the Rows to Repeat at Top text box.
Excel indicates the print-title rows 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.
Click in the Columns to Repeat at Left text box and then drag through the range of columns with the information you want to appear at the left edge of each page of the printed report in the worksheet below. If necessary, reduce the Page Setup dialog box to just the Columns to Repeat at Left text box by clicking the text box’s Collapse/Expand button.
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.
Click OK or press Enter to close the Page Setup dialog box.
The dotted line showing the border of the row and/or column titles disappears from the worksheet.
Rows 1 and 2 containing the worksheet title and column headings for the Little Bo-Peep Pet Detectives client database are designated as the print titles for the report in the Page Setup dialog box. Here, 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. Click OK or press Enter.