Specify Repeating Rows and Columns

Excel's Print Titles enable you to print particular row and column headings on each page of the report. Print titles are important in multi-page 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.

Choose Page Layout => Page Setup => Print Titles. The Page Setup dialog box opens. On the Sheet tab, type a dollar sign ($) followed by the row numbers or column letters you want to print as titles in the Print Titles section. Entering $2:$2, as you see in Figure, repeats row 2 at the beginning of each page. Click ok.

Click the worksheet icon on the right to collapse the Page Setup dialog box so you can select the rows or columns you want to include. Click the button again to return to the Page Setup dialog box.

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.