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 on all pages when you have large, complex worksheets.
Print headings or titles on every page - Microsoft Support
If you want to print a sheet that will have many printed pages, you can set options to print the sheet's headings or titles on every page. Excel automatically provides headings for columns (A, B, C) and rows (1, 2, 3). You type titles in your sheet that describe the content in rows and columns.
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. Follow these steps to add Print Titles to a worksheet:
Headers and footers in a worksheet - Microsoft Support
You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own, or use many built-in headers and footers.
Repeat table header on subsequent pages - Microsoft Support
You can set up the table so that the table header row or rows appear on each page automatically. You can choose from two ways to set up your table so that its header row or rows repeat. You can do the following: Select the header row or rows that you want to repeat on each page.
Print the top row on every page - Microsoft Support
Print the top row on every page. 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 Page Setup group, click Print Titles.
Video: Insert headers and footers - Microsoft Support
You can add headers to the top and footers to the bottom of a worksheet. When you print the worksheet, the headers and footers also print. For example, you might create a header with the file path and a footer with page numbers. Select the worksheet you want to add a …
Insert page numbers on worksheets - Microsoft Support
Add page numbers or other text to a header or footer. Learn what a header and footer is, and how to find them in Excel.
Change or delete a header or footer on a single page
Change or delete a header or footer from another single page. To delete or change headers and footers on individual pages within a document, start by inserting a section break.
Format text in headers or footers - Microsoft Support
Open the worksheet containing the header or footer text you want to format. Note: If you don't have a header or footer, add them by clicking Insert > Header & Footer. On the status bar, click the Page Layout View button. Select the header or footer text you want to change.