A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
To have column headers print on every page in Excel for Windows, set the header row as “rows to repeat at top” before printing.
- Open the workbook on the Windows desktop version of Excel (not Excel for the web).
- Select the worksheet that should print with repeating headers.
- Go to the Page Layout tab.
- In the Page Setup group, select Print Titles.
- If Print Titles is dimmed, ensure no cell is being edited, no chart is selected, and that a printer is installed.
- On the Sheet tab of the Page Setup dialog, under Print titles:
- In Rows to repeat at top, enter the row(s) that contain the column headings, for example:
$1:$1for the first row. - If needed, use Collapse Dialog to select the header row(s) directly on the sheet.
- In Rows to repeat at top, enter the row(s) that contain the column headings, for example:
- Click OK.
- Press CTRL+P and print; the specified header row will appear at the top of each printed page.
If the issue is that the Excel row/column labels (A, B, C, 1, 2, 3) themselves are not printing, enable them:
- Select the worksheet.
- Go to Page Layout.
- In Sheet Options → Headings, check Print.
- Press CTRL+P and print.
When emailing the file to another device, these settings are saved in the workbook, so the recipient (or the same user on another machine) should see the headers repeat as long as the file is opened in the desktop Excel app and printed from there.
References: