Repeat specific rows or columns on every printed page
On the Sheet tab, under Print titles, do one—or both—of the following: In the Rows to repeat at top box, enter the reference of the rows that contain the column labels. In the Columns to …
Print rows with column headers on top of every page
If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers …
Print headings or titles on every page in Excel for Mac
Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Select OK.
Print row and column headings - Microsoft Support
To print specific data at the top or side of each printed page—such as the names of the months that appear across the first row of a worksheet—see Repeat row or columns on every printed …
Repeat item labels in a PivotTable - Microsoft Support
Repeating item and field labels in a PivotTable visually groups rows or columns together to make the data easier to scan. For example, use repeating labels when subtotals are turned off or …
Print the top row on every page - Microsoft Support
In a worksheet that will take more than one page to print, you can print column headers on each page so the column headings can be seen on each page. On the Page Layout tab, in the …
Print a PivotTable - Microsoft Support
You can repeat the row labels and column labels of a report on every printed page as print titles. When you change the layout of the report so that the labels are shown in different worksheet …
Repeat table header on subsequent pages - Microsoft Support
In the table, right-click in the row that you want to repeat, and then select Table Properties. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of …
Page Setup - Microsoft Support
Print titles Select an option under Print titles to print the same columns or rows as titles on every page of a printed worksheet. Select Rows to repeat at top if you want specific rows as your …
Set or clear a print area on a worksheet - Microsoft Support
If you frequently print a specific section of your worksheet, you can set a print area for it. That way, when you print your worksheet, only that section will print.