Share via

excel column headings won't print on each page

SB 0 Reputation points
2026-03-12T14:56:16.57+00:00

when email excel to myself and open it the column headings won't print on each page

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Q&A Assist
    2026-03-12T14:56:30.5233333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To have column headers print on every page in Excel for Windows, set the header row as “rows to repeat at top” before printing.

    1. Open the workbook on the Windows desktop version of Excel (not Excel for the web).
    2. Select the worksheet that should print with repeating headers.
    3. Go to the Page Layout tab.
    4. 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.
    5. 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:$1 for the first row.
      • If needed, use Collapse Dialog to select the header row(s) directly on the sheet.
    6. Click OK.
    7. 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:

    1. Select the worksheet.
    2. Go to Page Layout.
    3. In Sheet OptionsHeadings, check Print.
    4. 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:

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.