How to Add a Header in Excel for All Pages

How-to basics · Updated November 18, 2026

To add a header to every printed page in an Excel worksheet, select the sheet, choose Insert > Header & Footer, and type in one of the header boxes. Excel repeats that header on the sheet’s printed pages by default. Check the result in File > Print; headers generally do not appear in Normal view.

What You’ll Need

  • A workbook opened in the Microsoft Excel desktop app for Microsoft 365. Excel for the web has limited page-layout editing; if you cannot add a header there, choose Open in Desktop App.
  • A worksheet you intend to print, plus the text, page numbering, date, or other information you want in the header.
  • Optional: a small logo image if you want a branded header. Keep a copy of the image file available on your computer.

Step-by-Step

  1. Select the worksheet. Click the tab for the sheet whose printed pages need a header. Headers belong to individual worksheets, not automatically to the entire workbook. If the same header is needed on several sheets, you will need to set it for each one. You can group worksheet tabs to apply the same setup to multiple sheets, but make sure to ungroup them afterward so later edits do not unintentionally affect every selected sheet.
  2. Open the header area. On Windows, select Insert > Header & Footer. Excel switches to Page Layout view and displays a header area above the worksheet. Another way is to select View > Page Layout, then click the space marked Add header at the top of a page. The header area is divided into left, center, and right sections; choose the section where you want the content to sit.
  3. Enter ordinary header text. Click a header section and type the text, such as a report name, department, or date label. Use the left section for information that should align with the left edge, the center for a centered title, or the right section for content aligned with the right edge. You can fill more than one section if you want, for example a report name on the left and a page number on the right.
  4. Add automatic information if needed. When a header section is active, use the Header & Footer tab and its Header & Footer Elements controls to insert items such as Page Number, Number of Pages, Current Date, File Name, or Sheet Name. These elements update when the workbook is printed or its details change. For a page count such as 1 of 5, insert Page Number, type a separator such as of, then insert Number of Pages. Avoid typing a page number manually if it should change from one printed page to another.
  5. Use a built-in header or create a custom one. You can select a preset from the Header & Footer tab’s Header menu, then replace its sample text as needed. For more control, open Page Layout > Page Setup using the small dialog launcher in the Page Setup group, and select the Header/Footer tab. Choose a built-in option or select Custom Header to enter content in the left, center, and right sections. This dialog is useful when you want to set the header without working directly in Page Layout view.
  6. Keep the same header on every page. Excel uses the same header for the printed pages of the worksheet unless you enable an exception. On the Header & Footer tab, leave Different First Page turned off if the first page should match the rest. Leave Different Odd & Even Pages turned off if odd and even pages should match. If either option is on, Excel provides separate header areas for the affected pages, so entering text in one may not fill the others.
  7. Check the page layout and print preview. Select File > Print, or press Ctrl+P on Windows (Command+P on Mac), to inspect the printed pages. Move through the preview pages to confirm the header repeats, is readable, and is not cut off. If it is too close to the top edge or overlaps the worksheet, return to the sheet and adjust the margins or header position in Page Layout > Page Setup. The printed result is the important check; the header may not be visible in Normal view.
  8. Save the workbook and repeat for other sheets. Save your changes after the preview looks right. If other worksheets need the same header, select each worksheet tab and add it there, or carefully group the relevant tabs before making the change. When grouping sheets, look for the grouped-tab indication, then right-click a selected sheet tab and choose Ungroup Sheets when finished. Preview each sheet because different print settings can make a shared header look different.

On Mac: The same basic method applies: choose Insert > Header & Footer, enter content in a header section, and use print preview to check it. Ribbon labels and dialog placement can vary slightly by Excel for Mac release; look in Page Layout or the Page Setup dialog for header and footer options. On Windows, the steps above use Microsoft 365 desktop Excel.

Common Mistakes

  • Expecting the header to show in Normal view. A worksheet header is a print-layout feature, so it may appear blank or absent while you work in Normal view. Switch to View > Page Layout or open File > Print to see it.
  • Confusing a header with repeated column headings. A header is printed in the page margin, typically above the grid. If you need column labels such as Date, Item, and Total to repeat above the table on every page, use Page Layout > Print Titles and set Rows to repeat at top. That setting is separate from a header.
  • Entering a page number as plain text. Typing 1 in a header does not create a changing page number; it prints the same character on each page. Insert the Page Number element instead. Add Number of Pages as well if readers need a total, such as 2 of 6.
  • Turning on a special-page option by accident. Different First Page and Different Odd & Even Pages can make a header appear on only some pages. Check these settings if a header is missing from the first page or alternating pages.
  • Setting the header on the wrong worksheet. Each sheet has its own header and print settings. Confirm the active sheet tab before editing, especially if the workbook contains several similar reports.
  • Assuming the header appears on screen or in a digital export exactly like a cell. Headers are positioned in the print layout, not in worksheet cells. Check print preview and any PDF export rather than relying on the grid view.

Tips

  • Keep the wording brief. A long header can collide with the page edge, a logo, or another section, particularly when the worksheet prints in landscape or at a reduced scale.
  • Use the three sections to control alignment rather than adding spaces to push text across the page. Spaces can shift unpredictably when paper size, margins, or scaling changes.
  • For page numbering, use the built-in elements instead of typing field codes yourself. A common arrangement is the report title in the center section and Page Number plus Number of Pages in the right section.
  • If you insert a logo, use the Picture control on the Header & Footer tab. Excel may show a placeholder while editing; use Format Picture if available to adjust its size, then inspect print preview for clipping or excessive height.
  • For a date that should reflect the print date, insert Current Date. If the header should show a fixed reporting period, type that period as text instead so it does not change later.
  • Review paper size, orientation, and scaling before fine-tuning the header. A layout that fits on one page wide may shrink the worksheet and make the header seem disproportionately large or small.

Troubleshooting

The header does not appear in print preview: Make sure you edited the correct worksheet and selected a header section rather than a footer section at the bottom of the page. Check whether Different First Page or Different Odd & Even Pages is enabled; if so, enter the header in the relevant page type or turn the option off. Also confirm that the worksheet is actually included in the print range.

The header appears only on the first page: Excel normally repeats a worksheet header on all its printed pages. If it seems limited to one page, inspect the preview page by page and check the special-page options. If you are printing multiple worksheets, remember that each sheet has its own header; setting one sheet’s header does not automatically set the others.

The header is clipped or too close to the paper edge: Open Page Layout > Page Setup and review the Margins tab. Increase the top margin or adjust the header margin so there is enough room between the paper edge, header, and worksheet. Check the selected paper size and printer settings too, since printable margins vary by printer. Reopen print preview after each adjustment.

The header looks different in the exported or printed file: The printer, paper size, scaling, and selected print area can affect pagination. Confirm these settings in File > Print and check the actual PDF or a test print. If you used a picture, resize it through the header picture formatting controls and preview again. Avoid judging the final result only from the worksheet grid.

You cannot edit the header in Excel for the web: Open the workbook in the desktop Excel app and use Insert > Header & Footer. After saving, you can return to the web version to view or share the workbook, but use desktop Excel when you need full header and print-layout controls.

Frequently Asked Questions

Does Excel repeat a header on every printed page automatically?
Yes. A worksheet header repeats across its printed pages by default. It will differ if you enable Different First Page or Different Odd & Even Pages, or if you are printing other worksheets with their own settings.

How do I add a header to every sheet in a workbook?
Headers are set per worksheet. Add the header to each sheet, or group the intended sheet tabs and apply the shared header once. Ungroup the tabs when finished, then preview each sheet because its print layout may differ.

Can I put page numbers in an Excel header?
Yes. Click a header section and choose Page Number from the Header & Footer Elements controls. To show a total as well, add Number of Pages and type a separator between the two elements.

Why can I see the header in print preview but not on the worksheet?
Headers are print-layout content, not cell values. Use View > Page Layout to see them while editing, or check File > Print. They are not normally displayed in the worksheet’s Normal view.

What is the difference between a header and repeating rows?
A header sits in the page margin and is suited to a title, date, or page number. Repeating rows repeat selected worksheet rows, often table column labels, at the top of each printed page. Set those rows separately with Page Layout > Print Titles.

Can I add a header in Excel for the web?
Header editing is limited in Excel for the web and may not be available for your workbook. Open it in desktop Excel for the full Insert > Header & Footer and Page Setup controls.

Related

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.