Excel Headers: How to Add Them to Every Printed Page

To add a header that repeats on every printed page in Excel for Microsoft 365 on Windows, choose Insert > Header & Footer, click a header area at the top of the sheet, and type your text. Excel repeats it across the worksheet’s printed pages by default. You can also add page numbers, a date, or a file name, then check the result in print preview.

What You’ll Need

An Excel workbook and the desktop version of Excel. Excel for the web does not provide the same controls for adding or editing printed headers; choose Open in Desktop App if you are working in a browser.
A printer, or access to File > Print, to preview the page layout. You do not need to connect a printer just to set up a header.
Optional: the wording, page information, or image you want to include. Keep it brief so the header does not crowd the worksheet.

Step-by-Step

Open the worksheet you plan to print. Headers belong to individual worksheets, not automatically to the entire workbook. If you want the same header on several sheets, you will need to set it on each one, or group the sheets and apply the change carefully. Before printing, confirm that you are working on the correct sheet tab.
Switch to the header editing view. Select Insert > Header & Footer on the ribbon. Excel changes to Page Layout view, which shows the worksheet as printable pages. At the top of the page, you will see three header areas: left, center, and right. If the sheet is zoomed out, the areas may be small, so zoom in or click within the top margin to locate them.
Choose where the header should appear. Click the left, center, or right header area. For example, put a report name in the center and a department or date at the right. Type ordinary text directly. You can use more than one section, but a short header is usually easier to read and less likely to overlap the worksheet.
Add automatic details if needed. Once a header area is selected, Excel displays the contextual Header & Footer tab. Use its Header & Footer Elements group to insert items such as Page Number, Number of Pages, Current Date, File Name, or Sheet Name. Excel inserts a field that updates when the workbook is printed or the relevant information changes. Do not type a page number manually if you need each page to have its own number.
Combine labels and fields thoughtfully. You can type text before or after an inserted field. For instance, click the right section, type the word Page and a space, then choose Page Number. The header will show Page followed by the correct number on each printed page. To show a total as well, add a separator such as a space, the word of, and the Number of Pages field. Preview the result to check spacing and avoid a long label running into another section.
Return to the worksheet and preview the pages. Click a worksheet cell or select View > Normal to leave Page Layout view. Then choose File > Print, or press Ctrl+P on Windows, to inspect the preview. Use the next-page controls in the preview to check more than the first page. Look at the top margin on each page and confirm that the header is readable, not clipped, and not covering important content.
Adjust the header if it sits too close to the edge. In the print screen, open Page Setup, then use the Margins tab to adjust the header margin or the top page margin. You can also open the Page Setup dialog from Page Layout: click the small dialog launcher in the Page Setup group, then select the Margins tab. Make small changes and preview again, because a margin adjustment can shift the worksheet content as well as the header.
Use the Header/Footer dialog for presets or more control. Select Page Layout, click the Page Setup group’s dialog launcher, and open the Header/Footer tab. Choose a preset from the Header list, or select Custom Header to edit the left, center, and right sections. This route is useful when you want to set a header without staying in Page Layout view. Select OK and check File > Print to verify the printed result.
Set special-page options only when you need them. In the Header/Footer tab of Page Setup, options such as Different first page and Different odd and even pages change the default repetition. With Different first page selected, the first printed page can have its own header or no header, while the remaining pages use the regular header. With Different odd and even pages selected, odd and even pages can use separate content. Leave these options cleared if the same header should appear on every page.

Mac note: In Excel for Mac, use Insert > Header & Footer to edit the three sections, or open Page Setup and its Header/Footer controls. The layout is similar, though ribbon labels and dialog placement can vary slightly by release. The common print shortcut on Mac is Command+P rather than Windows Ctrl+P. Excel for the web may let you view or print a workbook, but use the desktop app to create or change the header.

Common Mistakes

Confusing a printed header with a worksheet heading row. A header is placed in the page margin and is usually visible in printouts, not as a normal row in the grid. If you want column labels such as Product or Date repeated above the data on every page, use Page Layout > Print Titles and set Rows to repeat at top. You can use a printed header and repeating rows together; they serve different purposes.
Expecting a header to appear inside the worksheet cells. Header text does not occupy a row, so it will not show as a normal cell value in the standard worksheet grid. Use Page Layout view or File > Print to see how it will print. If you need the text visible while editing or included in sorting and filtering, put it in worksheet cells instead.
Entering page numbers as fixed text. Typing “Page 1” into a header makes that same text repeat on every page. Insert the Page Number field instead, and add Number of Pages if you want a total-page count. Fields update for the printed document and are more reliable if the number of pages changes.
Leaving special-page settings on unintentionally. Different first page or Different odd and even pages can make a header seem to disappear or change. Check these boxes in Page Setup > Header/Footer if pages do not match. Also remember that a worksheet’s header settings do not automatically carry over to other worksheet tabs.
Making the header too long or too close to the page edge. Long text, large font, and a narrow margin can cause clipping or collisions with the worksheet. Keep the wording concise, use separate left, center, and right sections sparingly, and check multiple pages in print preview before printing.

Tips

Keep the header useful, not crowded. A report name, date, or worksheet name is often enough. Put explanatory details in the worksheet itself rather than shrinking the header until it becomes difficult to read.
Use the Sheet Name field for multi-tab reports. It helps readers identify which worksheet a page came from. Remember that Excel still treats each worksheet’s print setup separately; the field displays the current sheet name, but does not configure headers on other sheets.
Make the page count meaningful. Number of Pages reflects the printed page count for that worksheet and its current print setup. If you change scaling, orientation, margins, or the print area, the total may change. Preview again after changing those settings.
Save after checking the layout. Header settings are stored with the workbook. Save the file after confirming the preview, especially if you have also changed margins, scaling, or print titles.
Use a logo only when it improves the document. In a custom header, select the section where the image should go and use the picture control if available in your desktop version. Check the preview because images may need resizing and can make the header taller. A logo in a header is not the same as a picture placed over worksheet cells.

Troubleshooting

The header is not visible on the worksheet. This is expected in Normal view. Select View > Page Layout or open File > Print to see the print header. It does not appear as text in a worksheet cell.

The header appears on the first page but not the others. Open Page Layout’s Page Setup dialog and select Header/Footer. Check whether Different first page or Different odd and even pages is enabled. If you want identical content everywhere, clear both options, choose or edit the regular header, and preview the pages again.

The text is cut off or overlaps the worksheet. Open Page Setup and review the Margins tab. Increase the top margin or adjust the header margin, shorten the text, or reduce the header’s font size. Then inspect the preview at normal viewing size; a header that looks fine when zoomed out may still print too small or too close to the edge.

The header is missing from another worksheet. Select that worksheet and set its header separately. If you group several sheet tabs to apply print settings together, take care: changes can affect every selected sheet, and grouped tabs can make normal editing confusing. Right-click a selected tab and choose Ungroup Sheets when finished.

The page numbers or total look wrong. Check that you inserted the Page Number and Number of Pages fields rather than typing static text. Next, review the print area and scaling: these determine how many pages Excel produces. If the workbook has several worksheets, preview each sheet’s printout because page numbering and page totals may be based on the individual sheet’s print setup.

Frequently Asked Questions

Will an Excel header repeat on every printed page?

Yes. A worksheet header repeats across its printed pages by default. It can vary if you enable Different first page or Different odd and even pages in Page Setup, so check those options if the header changes unexpectedly.

How do I repeat column headings at the top of each page?

Choose Page Layout > Print Titles. In the Page Setup dialog’s Sheet tab, set Rows to repeat at top by selecting the worksheet row or rows that contain your column labels. This repeats grid rows; it is separate from adding a header in the page margin.

Can I put a page number and total pages in the header?

Yes. Click a header section and insert the Page Number and Number of Pages elements from the Header & Footer tab, adding words or a separator between them if desired. Preview the printout to confirm that the fields display as intended.

Can I have a different header on the first page?

Yes. In Page Layout > Page Setup > Header/Footer, select Different first page. You can then enter a first-page header separately from the regular header used on later pages.

Can I add the same header to every worksheet at once?

Headers are worksheet-specific. You can group sheet tabs and apply a setting to selected sheets, but changes made while sheets are grouped may affect all of them. For a small number of sheets, setting and previewing each one individually is often the safer approach.

Why can’t I edit the header in Excel for the web?

The web version has fewer page-layout editing features than desktop Excel. Open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac to add or change printed headers, then save the workbook so the settings are retained.

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.