When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.

Print column headings on each page of your worksheet so your readers won’t have to go back to the first page to see the headers.

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 on all pages …

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 each page …

Repeating item and field labels in a PivotTable helps you use VLOOKUP or other functions to retrieve information.

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.

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.

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 page.

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.

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.