Print Rows With Column Headers On Top. Click the icon at the far right of the Rows to repeat area. Open the desired workbook and click the tab at the bottom for the worksheet for which you want to print row and column headings.
When the records belonging to a group span across multiple columns I want to print the header. Click the Page Layout tab if its not already the active tab. You can notice that the cursor changes to the black arrow.
For example if you want to print the first row headings on every page you can type 11 and if you want to print multiple rows on every page for example rows 1-2 you just type 12 on the Rows to repeat at top text box.
On the Page Layout tab in the Page Setup group click Print Titles. In the Sheet Options group under Headings select the Print check box. On the Page Layout tab in the Page Setup group click Print Titles. In the text entry box in the center type in the rows to repeat.
