How to Use the Print Titles Feature in Excel 2013
2 of 4
Select 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.
Note that 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.
