Add a Header in Excel on Every Printed Page

To add a header that repeats on every printed page in Excel for Microsoft 365 on Windows, open Page Layout > Page Setup using the small dialog launcher, choose the Header/Footer tab, and select Custom Header. Enter the text or fields you want, then check the result in Print Preview. Headers repeat when a worksheet is printed or saved as a PDF; they do not appear in the usual Normal worksheet view.

What You’ll Need

An Excel workbook with the worksheet you want to print.
A general idea of what the header should show, such as a report name, date, page number, or business name.
Optional: a printer, or the option to print to PDF, for checking the finished pages.

You do not need a formula or add-in. A header is a print-layout setting for an individual worksheet, so if your workbook has several sheets, you may need to set up each one separately.

Step-by-Step

Select the worksheet. Click the sheet tab that you want to print with a header. If the header should appear on several worksheets, you can select multiple sheet tabs first by holding Ctrl while clicking each tab on Windows. Be cautious with grouped sheets: changes made while several sheets are selected can affect all of them. To work on just one, right-click a selected tab and choose Ungroup Sheets, or click a single sheet tab.
Open Page Setup. Select the Page Layout tab. In the Page Setup group, click the small diagonal arrow in the lower-right corner to open the Page Setup dialog box. If you do not see the ribbon, expand it or use Excel’s search box to find Page Setup. The dialog contains settings for margins, paper orientation, paper size, and headers and footers.
Choose a header style or open the custom editor. In Page Setup, select the Header/Footer tab. Open the Header dropdown to choose a built-in option, such as a page number or sheet name. For your own wording, select Custom Header. The custom editor has three areas: Left section, Center section, and Right section. Click the section where you want the content to print.
Enter the header content. Type plain text directly into the chosen section, for example Quarterly Sales Report. You can use more than one section; a common layout puts the report title in the center and a page number on the right. To insert an automatic page number, date, time, file name, or sheet name, use the corresponding buttons in the Custom Header dialog rather than typing a value that will go stale. Excel inserts a special field that is filled in when the sheet is printed.
Format the text if needed. In the Custom Header dialog, select the text or field you want to change and use the font-formatting button. You can adjust the font, size, and style. Keep the header readable and reasonably short: a large font or a long title can use up the top margin and leave less room for worksheet data. Click OK to close the custom editor, then click OK again in Page Setup to apply the setting.
Set the page layout before judging the result. On Page Layout, review paper size, orientation, margins, and scaling. A header is positioned within the page’s top margin, so a narrow margin or a large header may make the page look crowded. If the worksheet spans multiple printed pages, confirm that the scaling is sensible and that the header will not overlap the table. Headers repeat across the printed pages of that worksheet automatically; you do not have to copy the text to each page.
Preview the printed pages. Press Ctrl+P on Windows to open the print screen and inspect the preview. Use the page arrows to check more than the first page, particularly if the sheet has several pages or different page orientations. If the header is missing, too close to the edge, or collides visually with the data, return to Page Setup and adjust the header, margins, or scaling. On a Mac, use Command+P to open the print dialog and preview.
Print or create a PDF. When the preview looks right, choose a printer and print, or choose a PDF option in the print dialog to save a shareable copy. The header belongs to the worksheet’s page setup, so it will be included in printed output and PDF output. Save the workbook as well if you want the header setting to remain available the next time you open it.

Alternative method: You can also choose Insert > Text > Header & Footer on Windows. Excel switches to Page Layout view and displays header areas at the top of the page. Click the left, center, or right area and type, or use the contextual Header & Footer tab to insert fields and choose a preset. This is convenient for a quick edit; Page Setup is useful when you also need to adjust margins or options for different pages.

In Excel for Mac, use Insert > Header & Footer to add or edit the header, or use the page setup controls available from the Page Layout ribbon. Ribbon labels and dialog placement can vary slightly by Excel release. Excel for the web has limited page-layout editing; if you cannot find header controls, open the workbook in the desktop Excel app to add the header.

Common Mistakes

Expecting the header to show in the grid. In Normal view, Excel displays cells rather than the printed header area. Switch to Page Layout view or check Print Preview to see it. A blank-looking worksheet in Normal view does not mean the header was lost.
Confusing a header with repeating column labels. A header is printed in the page margin. If you need the top row of a data table to repeat at the top of every page, use Page Layout > Print Titles and set Rows to repeat at top. That repeats worksheet cells, not header content. You can use both features together.
Typing a page number as ordinary text. A typed 1 stays 1 on every page. Use the page-number field in the custom header so Excel numbers each printed page automatically. If you want wording such as Page 1 of 4, insert both the page number and total-pages fields.
Leaving a special-page option enabled unintentionally. In the Header/Footer tab, Different first page can leave the first page without the regular header unless you fill in its separate first-page header. Different odd and even pages allows separate content on alternating pages. Turn these options off if you want the same header on every page.
Judging a header without checking page breaks. Scaling, print area, and orientation determine how many pages Excel produces. A header can be correct while the worksheet still prints across an unexpected number of pages. Inspect all pages, not just the first preview.

Tips

Use the three sections deliberately. Put a document title in the center, a date on the left, or a page number on the right. Separating items makes the header easier to scan and avoids manually inserting spaces to line things up.
Choose dynamic fields for changing details. The date, file name, and page number fields update based on the workbook and print job. They are especially useful for reports that are revised or printed regularly. Use fixed text only for information that should not change.
Keep the header concise. Long titles may wrap or crowd the page. If the report name is lengthy, shorten it or reduce its font size rather than shrinking the worksheet until the table becomes difficult to read.
Check print margins as well as header text. The header position is affected by the top margin and header margin. If the text sits too close to the page edge, open Page Setup’s Margins tab and increase the top margin or adjust the header distance. Confirm the change in preview.
Set up multiple sheets intentionally. Each worksheet can have its own header. For sheets that should share one layout, select their tabs together before making the change, then ungroup them and inspect each sheet. Avoid grouping unrelated sheets, since you could accidentally apply the same setting to all of them.

Troubleshooting

The header does not appear when printing. Reopen Page Setup and make sure the Header dropdown is not set to (none). Check whether Different first page is enabled and whether you are previewing that first page. Confirm that you are printing the worksheet with the header, not a different sheet, and that you are viewing the print preview rather than the worksheet grid.

The header appears on some pages but not others. Look for the different-first-page and odd/even-page options in the Header/Footer tab. If those options are intentional, Excel uses separate header content for those page types; add the desired content to each applicable header. If you want identical content throughout, turn the options off and preview the pages again.

The header is cut off or overlaps the worksheet. In Page Setup, adjust the top margin and header position, then reduce the header font size or shorten its text if necessary. Also check paper size and orientation. A header may look fine on screen but clip on a printer with larger non-printable margins, so preview using the intended paper size and printer when possible.

The page number or date prints as strange characters. Edit the header through Custom Header and insert the field with its toolbar button. If you typed field-like characters by hand, delete them and insert the correct field from the dialog. Then preview again; Excel fills the field when rendering the page.

You cannot find the header controls. Confirm that you are using the desktop version of Excel. In Excel for the web, open the workbook in the desktop app if the insert or page setup options are unavailable. On Windows, the direct route is the Page Setup dialog launcher on the Page Layout tab; the alternative is Insert > Text > Header & Footer.

Frequently Asked Questions

Does an Excel header appear on every page automatically?
Once you add a header to a worksheet, Excel repeats it on each printed page by default. It is not repeated as visible text in the worksheet cells or Normal view.

Can I put a different header on the first page?
Yes. Open the Header/Footer tab in Page Setup and select Different first page. Excel provides a separate first-page header area, so enter content there as well as in the regular header if you want both to show.

How do I show Page 1 of 5 in the header?
Choose Custom Header, click the section where the numbering should go, and insert the page-number and total-pages fields using their buttons. Excel supplies the actual page number and page count when it prints; the total can change if the print area or scaling changes.

Can I add a logo to an Excel header?
Yes. In the Custom Header dialog, select a section and use the picture button to insert an image, then use the format-picture control to adjust it. Check Print Preview because a large logo can crowd the header or reduce space for the worksheet.

Why can I see the header in Print Preview but not on the worksheet?
That is expected in Normal view. Headers are print-layout content, not cell values. Use View > Page Layout to see the page area while editing, or use Print Preview to inspect the final output.

Will this header appear on every worksheet in my workbook?
No. Page headers are set separately for each worksheet. Apply the setting to the other sheets as needed, or group the intended sheets before making the change and then verify each sheet’s preview.

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.