Add a Header in Excel on the First Page Only

To add a header only to the first printed page in Excel for Microsoft 365 on Windows, open the worksheet in Page Layout view, select Header & Footer > Options > Different First Page, then enter text in the first page’s header area. Leave the regular header blank if you want later pages to have no header. This setting affects printed pages, not the worksheet grid itself.

Before you start, make sure you are editing the worksheet you intend to print and that its print layout is roughly set. Excel uses page breaks, paper size, orientation, margins, and scaling to determine what counts as page one. You can adjust those settings later, but checking them first makes it easier to confirm that the header is on the page you expect.

What You’ll Need

A workbook open in the desktop version of Excel for Microsoft 365 on Windows.
A worksheet with content to print, or a saved copy of the workbook if you want to preserve the original print setup.
The header text or items you want on page one, such as a report name, date, or page number.

Step-by-Step

Select the worksheet you want to print. Click its sheet tab at the bottom of the Excel window. Headers and page setup are stored per worksheet, so selecting the right sheet matters. If you plan to print several sheets, you will need to set this option for each one. Avoid selecting multiple sheet tabs unless you deliberately want to group sheets and apply the same settings to them.
Check the page layout before adding the header. Select Page Layout > Size to confirm the paper size, and use Page Layout > Orientation to choose Portrait or Landscape. Check Page Layout > Scale to Fit if the worksheet is being scaled to fit a page. These choices can change where page one ends and how many pages Excel prints. You can also select View > Page Break Preview to inspect the page divisions. Return to Page Layout view before editing the header.
Open the header area. Select Insert > Header & Footer. Excel switches the worksheet to Page Layout view, where each printed page is shown separately. Scroll to the first page if needed, then click the top area labeled Add header. If the sheet is wide or tall, use the horizontal and vertical scroll bars to locate the first printed page rather than assuming the page currently on screen is page one.
Turn on a separate first-page header. Click inside the header area to show the contextual Header & Footer tab. In its Options group, select Different First Page. Excel now treats the first page’s header separately from the regular header used on later pages. The first page header area is identified as the first-page header; later pages use the standard header area.
Enter the header on page one. Click the left, center, or right section of the first page’s header and type your text. For example, put a report title in the center section and a department name in the left section. To insert an automatic date, time, page number, or file name, use the relevant buttons in the Header & Footer Elements group on the contextual tab. Those elements update from the workbook or computer information rather than remaining ordinary typed text.
Keep later-page headers empty. Scroll to page two and look at its regular header area. If it is empty, there is nothing else to do. If it contains a header from an earlier setup, click that header and remove its contents. Do not remove the text from the first-page header by mistake: check that the area is the regular header on a later page before editing it. With the regular header blank, the first-page header is the only one that prints.
Review the result in Print Preview. Select File > Print to open the print preview. Check the preview of page one and at least one later page. The header should appear at the top of page one and not on subsequent pages. If the preview shows only one page, temporarily check the page count or adjust the worksheet’s print area and scaling so that you can verify a later page too. Exit the print screen without printing if you only want to inspect the result.
Save the workbook. Select File > Save or press Ctrl+S on Windows. The header and its different-first-page setting are part of the worksheet’s page setup, so saving the workbook preserves them for the next time it is opened. If you are using a shared workbook or a copy, confirm that you are saving the file you intend to print.

On a Mac, the workflow is similar: use Insert > Header & Footer, click in the header, then use the Header & Footer controls to enable Different First Page. Ribbon placement and labels can vary slightly by Excel version. Excel for the web may not expose all the desktop page setup and first-page header controls; open the workbook in the desktop app if you cannot find the setting.

Common Mistakes

Adding text without enabling Different First Page. If you simply type into the regular header, Excel repeats it on every printed page. Turn on the separate first-page option before entering the page-one text.
Leaving an old regular header in place. The option creates a separate first-page header; it does not automatically erase a header already assigned to later pages. Check page two and clear the regular header if it should be blank.
Editing the wrong worksheet. Each sheet has its own print setup. A correct header on one tab will not automatically appear on another tab, even if the sheets are part of the same workbook.
Confusing a worksheet heading with a header. Text typed into a cell is part of the grid and may print wherever that cell falls. A header is a page-layout element above the grid and is managed through Header & Footer.
Checking the grid instead of the printed page. Headers are designed for print layout and may not be visible in Normal view. Use Page Layout view or File > Print to check what will appear on paper or in a PDF.

Tips

Keep the wording short. A long header can run into another header section or be clipped near the page edge, especially when the sheet is printed in portrait orientation.
Use the left, center, and right header sections to separate information. For instance, place a report name on the left and a date on the right instead of putting everything into one long line.
Use Excel’s header element buttons for items that should update automatically. A typed date stays as typed; the Date element can display the current date when the sheet is printed.
Check margins if the header is too close to the paper edge or overlaps the worksheet. Use Page Layout > Margins to review the available space, and check the printer’s own printable-area limits if the preview or printout clips content.
Remember that “first page” means the first page in the worksheet’s print order. If the print area, page breaks, or page order changes, the page that receives the distinct header may change too.

Troubleshooting

The header appears on every page. Return to the sheet, click in a header area, and confirm that Different First Page is selected on the Header & Footer tab. Then inspect page two. If its standard header contains text, remove that text while leaving the first-page header intact. Reopen File > Print to verify the change.

The header does not appear in the preview. Confirm that you entered text in the area labeled for the first page, not in the regular header on a later page. Also check that you are previewing the same worksheet you edited and that the print area includes the worksheet content you expect. If the header is still missing, click back into the header area and check that the text is present; it can be easy to type into a cell instead of the header box.

The header is on a different page than expected. Review the print order, page breaks, and print area. Select Page Layout > Print Area to check whether a restricted print area is changing what gets printed, and use View > Page Break Preview to see the page sequence. Adjust the layout, then verify which page is first in Print Preview.

The text is cut off or overlaps the worksheet. Shorten the header, move part of it into another header section, or adjust the header and top margins. Also check the paper size and orientation. A print preview can look different from the physical output if the selected printer has different paper settings or printable margins, so confirm the printer and paper options before printing a final copy.

You cannot find the option. Click inside the header area first; the contextual Header & Footer tab appears when the header or footer is active. If the desktop ribbon still does not show the option, switch to the desktop Excel app and open the sheet in Page Layout view. The web app and older versions may have different controls.

Frequently Asked Questions

Does this add a header to only the first worksheet page or the first sheet tab?
It applies to the first printed page of the worksheet where you enabled the setting. It does not mean the first sheet tab in the workbook. Set the option separately on other worksheets if they need the same treatment.

Will later pages be blank automatically?
They will be blank only if the regular header used on later pages is empty. Excel keeps that header separate, and existing content can remain there when you enable Different First Page. Check a later page and clear its regular header if needed.

Can I put a page number in the first-page header?
Yes. Click the first-page header section where you want the number and select the Page Number element on the Header & Footer tab. Preview the result, especially if you also have other text in that section.

Can the first page have a header while later pages have a different header?
Yes. Enter the special text in the first-page header and enter different text in the regular header used on later pages. If you want later pages to have no header, leave that regular header empty instead.

Does the header show in Normal view or in the cells?
No. A header is part of the page layout, not a cell value. View it in Page Layout view or in File > Print; it will not appear as text in the worksheet grid.

Does the setting also apply to footers?
The Different First Page option separates both the first-page header and first-page footer from the regular header and footer. You can use either one, both, or neither. Check the footer areas as well if you do not want any footer on later pages.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.