To add a header that repeats on printed pages in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Text > Header & Footer, click a header area, and type text or insert a field such as a page number. Check the result in File > Print before printing. A print header is separate from worksheet cells, so it can appear on each printed page without changing the data in your sheet.
What You’ll Need
- An Excel workbook with the worksheet you plan to print.
- A desktop version of Excel for the steps below. Excel for the web may have fewer page setup and header editing options; if you cannot find the commands, open the workbook in the desktop app.
- Optional: the wording, logo, date, page number, or file details you want to show. You do not need to prepare a special header row in the worksheet.
Step-by-Step
-
Select the worksheet you want to format. Click its sheet tab at the bottom of the Excel window. A header is a page setup setting for a worksheet, not a workbook-wide banner by default. If you want the same header on several sheets, you can group those sheets first by selecting one tab, holding Ctrl on Windows, and selecting the other tabs. Be careful: changes made while sheets are grouped can affect every selected sheet. Click an unselected tab when you are finished to ungroup them.
-
Check what will print. Choose File > Print to open Print Preview, then use the back arrow to return to the sheet. This is a useful first check if the worksheet has a defined print area, hidden columns, or multiple pages. You can also review orientation and paper size on the Page Layout tab. Set these before fine-tuning the header, because changing page layout can alter where page breaks fall.
-
Open the header editing area. On the ribbon, choose Insert > Text > Header & Footer. Excel switches to Page Layout view and displays header and footer boxes above and below the worksheet page. You will see three header sections: left, center, and right. These sections help position information across the page. If the command is not visible, widen the Excel window or look for the Text group on the Insert tab.
-
Choose where the header should appear. Click inside the left, center, or right header box. For example, place a report title in the center and a department name on the left. A blinking cursor means the box is active. If you click the worksheet cells instead, you will edit cell content rather than the header, so check that the cursor is in the header area before typing.
-
Type the text or add a built-in field. You can enter plain text such as Quarterly Sales Report. To insert changing details, use the Header & Footer tab that appears while the header is active. Its Header & Footer Elements controls include items such as Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, and Sheet Name. Click an element where you want it to appear. Excel inserts a field that updates when the workbook is printed or viewed; it is not ordinary text to replace by typing over it.
-
Build a useful page number label if needed. To show a label such as Page 1 of 4, type Page and a space, insert Page Number, type a space, type of, add another space, and insert Number of Pages. Excel displays the current page and the total number of pages in the printed sheet. The total can change if you alter the print area, scaling, paper size, or page breaks. Check the preview rather than assuming the page count will stay fixed.
-
Format and position the header. Select the header text you want to change, then use the formatting controls available while editing, such as font, size, or bold. Keep the type readable at the paper size you will use. To adjust how much room is left above the worksheet, open the Page Layout tab and click the small dialog launcher in the Page Setup group. On the Margins tab, review the Header margin and the top margin. A header positioned too close to the worksheet can look crowded or overlap the printed area.
-
Review header options. On the Header & Footer tab, check whether Different First Page or Different Odd & Even Pages is enabled. These options allow different headers on the first page or on alternating pages. They are useful for a cover page or a two-sided report, but can make a header seem to disappear if you only filled in one version. Leave them off for a consistent header on every page.
-
Preview and print. Choose File > Print and inspect every page in the preview controls. Confirm that the header is legible, appears in the intended position, and does not collide with the worksheet. Check that fields such as page numbers and dates look right. If you need to revise anything, return to the sheet, click in the header, make the change, and preview again. When it looks correct, select the printer and print settings, then click Print.
Alternate route: You can create or edit a header through the Page Setup dialog. On the Page Layout tab, click the small dialog launcher in the Page Setup group, open the Header/Footer tab, and choose a preset or select Custom Header. In the custom dialog, enter content in the left, center, or right section, using the buttons to insert fields. This route is handy when you want to configure a header without editing directly on the page. Excel for Mac has similar header and footer tools, though ribbon placement and dialog layout can vary by release.
Common Mistakes
-
Typing a title into a worksheet cell and expecting it to repeat. A cell title prints only where that cell falls in the page layout. Use the page header for information that should repeat at the top of printed pages. If you want column labels repeated as well, use print titles separately.
-
Confusing a header with repeated rows. A header is a small area outside the grid that can hold text and fields. To repeat worksheet rows, go to Page Layout > Print Titles, then set Rows to repeat at top in the Page Setup dialog. These features can be used together: a header can show the report name while repeated rows show column headings.
-
Expecting to see the header in Normal view. Headers and footers generally do not display in the regular worksheet grid. Use Page Layout view or File > Print to inspect them. Their absence from Normal view does not mean they were not saved.
-
Forgetting that each worksheet has its own setup. Adding a header on one tab does not automatically add it to every other tab. Set up each sheet individually, or group the intended sheets and apply the change carefully. Ungroup sheets afterward to avoid accidentally editing multiple tabs.
-
Leaving different-page options on unintentionally. If Different First Page is selected, the first page has a separate header area. If that area is empty, page one may print without the header shown on later pages. Check the Header & Footer tab options and fill each required area.
-
Making the header too long or too small. Long text may run into another header section or become hard to read when printed. Very small type can look acceptable on screen but be difficult on paper. Keep wording brief and preview at the intended paper size.
Tips
-
Use the center section for a document title, the left section for a team or organization, and the right section for a date or page number. This arrangement is only a starting point; choose sections that suit your page orientation and reading order.
-
Use the built-in File Name and Sheet Name fields when printed pages might be separated from the workbook. They help identify where a page came from. If you move or rename the file or sheet, check the preview to confirm the printed details are still appropriate.
-
Keep headers concise. A title, date, and page number are often easier to scan than a full sentence. If the header contains sensitive file paths or identifying details, remove those fields before sharing printed copies outside your organization.
-
Use Print Preview after changing scaling, orientation, margins, or the print area. These settings affect page breaks and may change the total page count, even when you have not edited the header itself.
-
If you want a logo, use the Picture option in the Header & Footer tools where available, then use Format Picture to adjust it. Check that the image is small enough to fit in the header and prints clearly. The picture may not be visible as a normal worksheet object.
-
For a clean test, print one page or save the worksheet as a PDF and inspect it before printing a large batch. A PDF preview can reveal clipped text or unexpected page breaks without using a stack of paper.
Troubleshooting
The header does not appear in the printout: Confirm that you edited the correct sheet and are looking at Print Preview rather than Normal view. In Page Layout view, click the header area to check that it contains content. Then check whether Different First Page is enabled, or whether the header was entered only in an odd-page or even-page section. If you are printing a selected range or using a print area, verify that the correct worksheet pages are included.
The header appears on screen but not on paper: Open File > Print and inspect the preview. If it appears there but not on a physical page, check the printer’s paper size and print settings. A printer can clip content near page edges. Increase the top margin or move the header content away from the edge, then preview again.
The header overlaps the worksheet: Open Page Layout > Page Setup using the dialog launcher, then review the margins. Increase the top margin or adjust the Header margin so there is enough space between the header and the grid. Also check scaling: fitting a wide sheet onto one page can shrink the worksheet and make the header’s size seem disproportionate.
The page number or total pages look wrong: Check the preview page by page and confirm the print area, paper size, orientation, and scaling. Those settings determine pagination. If you only see a field code while editing, that is normal; Excel resolves it in the print preview. To show a simple fixed label instead, remove the field and type the wording you want.
You cannot find the header command: Make sure you are using the desktop Excel app and have a worksheet selected. On Windows, look under Insert > Text > Header & Footer. If the ribbon is simplified or the window is narrow, some commands may be collapsed. You can also use the Page Layout tab’s Page Setup dialog. In Excel for the web, open the file in the desktop app if the header editing controls are unavailable.
Frequently Asked Questions
Will the header print on every page?
Yes, by default a worksheet header repeats on each printed page for that sheet. The Different First Page and Different Odd & Even Pages options can create exceptions, so check them if one page looks different.
Can I add page numbers to the header?
Yes. Click in a header section and use Header & Footer > Page Number. To show a total as well, add Number of Pages. Review Print Preview because the displayed total depends on the worksheet’s pagination.
How do I repeat column headings at the top of each page?
Use Page Layout > Print Titles, not the header box. In the Page Setup dialog, set Rows to repeat at top to the row or rows containing the column labels. This repeats actual worksheet cells, while the header remains outside the grid.
Can I add a header to only the first printed page?
Yes. Edit the worksheet’s header and enable Different First Page on the Header & Footer tab. The first page has a separate header area, so add the desired text there and leave the other-page header blank if that is the effect you want.
Can I use a different header for each worksheet?
Yes. Select each sheet tab and set its header separately. If you group sheets to apply identical settings together, make sure they are the sheets you intend to change and ungroup them afterward.
Related
- How to Hide Columns in Excel on Mac Without Losing Data
- Add a Plus Sign to Hide Columns in Excel with Grouping
- Hide Excel Columns Based on Cell Values Automatically
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Compare Two Excel Sheets and Find DifferencesTo compare two Excel sheets cell by cell, put a formula on a third sheet such as =IF(Sheet1!A1=Sheet2!A1,"Same","Different"),…
- Outlook Automatic Rules: How to Create and Manage ThemCreate an automatic rule in Outlook by choosing a condition, such as who sent a message or a…
- Excel Not Keeping Formatting After Saving? Fixes That WorkExcel usually stops keeping formatting because the workbook was saved in a format that cannot store it, the…
- Google Sheets Calendar Dropdown: How to Add OneTo add a calendar picker in Google Sheets, select the cell, choose Format > Number > Date, then…
- Create a Dropdown List in Excel: Setup, Sources, and TipsTo create a dropdown list in Excel for Microsoft 365 on Windows, select the cell or cells, go…
- How to Mark Duplicates in Google Sheets with ColorTo mark repeated values in Google Sheets, select the cells you want to check, open Format > Conditional…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.