How to Add a Header in Excel

How-to basics · Updated November 18, 2026

To add a printable header in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert > Header & Footer, then click a header box at the top of the page and type your text. You can also insert items such as the page number, date, workbook name, or worksheet name. A print header is separate from worksheet cells: it appears on printed pages and in page layout views, but it does not create a heading row in your data.

What You’ll Need

  • An Excel workbook with the worksheet you want to print.
  • A clear idea of what the header should show, such as a report title, department, date, or page number.
  • Access to Excel for Microsoft 365 on Windows for the exact steps below. Excel for Mac has a similar Insert tab workflow; Excel for the web may have fewer header and footer editing options, so use the desktop app if the controls are unavailable.

Step-by-Step

  1. Open the correct worksheet. Open the workbook and select the sheet whose printed pages need a header. Headers are set separately for each worksheet, so adding one to a summary tab does not automatically add it to every other tab. If the workbook has several sheets, check the active sheet name before making changes. Save the workbook first if you want a simple way to return to the original version.
  2. Open the header editing view. On the ribbon, choose Insert > Header & Footer. Excel switches to Page Layout view and displays a header area above the worksheet grid. The header is divided into left, center, and right sections. If you do not see the command, widen the Excel window or check the Insert tab for a Text group; a narrow window can collapse ribbon commands.
  3. Select a header section. Click the box labeled Add header or click the left, center, or right header area. Choose the position based on how you want the printed page to look: a report title often works well in the center, while a company or project name may fit on the left. You can use more than one section, for example a title on the left and a page number on the right.
  4. Enter ordinary text. Type the text directly into the selected box. For example, you might enter Quarterly Sales Report or Inventory Summary. Press Tab to move between the left, center, and right sections while editing. Keep the wording concise because a long title can run into content in another section, particularly when the page is printed in portrait orientation.
  5. Add a changing field when needed. After selecting a header box, use the Header & Footer tab that appears on the ribbon. In the Header & Footer Elements group, choose options such as Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, or Sheet Name. Excel inserts a field code rather than fixed text, so the displayed value can update when the workbook is printed or opened. For example, place Page Number in the right section and type Page before it to display wording such as Page 1.
  6. Use a built-in header layout if it suits the document. On the Header & Footer tab, use the Header control to choose a preset arrangement. Presets commonly combine fields such as the file name, date, or page number in the three sections. Selecting a preset replaces or changes the current header content, so use it before doing detailed manual editing, or review the result carefully afterward.
  7. Format or remove an element. To format header text, select the relevant text while editing and use the formatting controls on the Header & Footer tab, where available, or the font controls shown for the selection. To remove an unwanted field or wording, click in its section, select the characters or field, and press Backspace or Delete. Take care not to remove surrounding text you want to keep. If formatting looks different from the worksheet font, remember that header text has its own formatting.
  8. Check the print layout. Click a worksheet cell or choose View > Normal to leave header editing. The header may no longer be visible in Normal view; that does not mean it was deleted. Choose File > Print to check the print preview. Confirm the text is positioned correctly, fields show useful values, and the header is not cut off. Use the print preview navigation to inspect more than the first page if the sheet spans multiple pages.
  9. Adjust page setup if the header is crowded. If the header is too close to the top edge or overlaps the printed area, return to the sheet and open the Page Setup dialog from the Page Layout tab. Review the Margins settings, including the header margin, and adjust them in small increments. You can also change orientation or scaling if the worksheet is unusually wide. Preview again after each change, since scaling and margins affect how much room is available on the page.
  10. Save the workbook. Choose File > Save or press Ctrl+S on Windows. On Mac, use Command+S. The header settings are stored with the workbook. When you print, use File > Print or Ctrl+P on Windows; on Mac, use Command+P. Check the preview and selected printer before sending the job.

On Excel for Mac, select the worksheet and use Insert > Header & Footer, then click the header area and enter text or choose header elements from the contextual Header & Footer controls. The names or placement of ribbon controls can differ slightly by Mac release, but the left, center, and right header sections work in the same way. In Excel for the web, header and footer editing may not be available for every workbook or interface. If you cannot find the command, open the file in the desktop version of Excel rather than trying to imitate a print header with worksheet cells.

Common Mistakes

  • Typing a title into a cell and expecting it to be a print header. Text in a cell is part of the worksheet grid. It will not automatically repeat at the top of each printed page. Use Insert > Header & Footer for a page header. Conversely, if you want column labels such as Date, Product, and Amount above your data, put those labels in a worksheet row, not in the print header.
  • Assuming the header should appear in Normal view. Excel often hides the header while you work in Normal view. Inspect it in Page Layout view or File > Print instead of recreating it because it is not visible on the grid.
  • Expecting one edit to update every sheet. Each worksheet has its own page setup and header. A workbook with separate monthly tabs may need the header added to each sheet. If you select multiple sheet tabs to edit them together, Excel groups those sheets; edits can affect all selected sheets. Ungroup them afterward by selecting a single sheet tab.
  • Putting too much information in one section. Long text can collide with a field in another section or become hard to read. Divide information between left, center, and right, shorten the wording, or move some details into a footer.
  • Using a field that displays the wrong information. File Name, Sheet Name, and Current Date are different fields. A date field may show the current date rather than a report date you need to preserve. For a fixed reporting period, type the intended date as ordinary text and verify it in print preview.

Tips

  • Choose a useful reading order. Put the report name or topic on the left or center, then put page numbering on the right. Readers can identify the document first and find their place second. Avoid adding decorative text that competes with the worksheet content.
  • Use page numbering that explains the total. Insert both Page Number and Number of Pages in a section, with wording such as Page before the first field and of between the fields. Excel will display a sequence such as Page 1 of 4. Check that the print area and scaling produce the expected total number of pages.
  • Keep fixed and changing information distinct. A report title or a date that identifies a particular reporting period is often best typed as ordinary text. Use a date field when you specifically want the date Excel generates for the printout. This prevents a later print from silently showing a different reporting period than the report covers.
  • Check each sheet and page orientation. A header that fits a portrait page may look awkward on a landscape page or on a sheet with many printed columns. Preview representative pages, especially if different sheets have different layouts. Adjust the text or page setup for the specific worksheet rather than assuming one arrangement fits the entire workbook.
  • Use the footer for secondary details. A file name, confidentiality note, or page number can go at the bottom instead if the top of the page is already busy. The Footer control on the Header & Footer tab opens the corresponding footer area; its sections and available elements work much like those for a header.

Troubleshooting

The header is missing from the printout. First confirm that you edited the same worksheet you are printing. Open File > Print and inspect the preview. If the header is absent there, return to Insert > Header & Footer and confirm that text or a field is actually in one of the header sections. If you only see it in Page Layout view but not in the preview, review Page Setup and the selected print settings, then reopen the preview.

The header appears on the first page but not later pages. A normal worksheet header repeats on pages generated from that worksheet. If later pages appear to lack it, check whether those pages belong to another sheet, whether you are looking at a separate print job, and whether the preview is showing the expected page range. Also confirm that the later pages are not being created from a different worksheet with its own header settings.

The header is clipped or overlaps the worksheet. Shorten the text, separate items across the three sections, or reduce the font size. Then check the header margin in Page Layout > Page Setup and inspect the preview again. If the worksheet begins too close to the header, increase the available spacing; if the header is cut off at the paper edge, check printer margins and paper size as well. Different printers can have different non-printable areas.

A field displays a code or an unexpected value. Click the header section and check that you inserted the field using the Header & Footer tab rather than typing a code-like string yourself. Return to print preview to see the field’s rendered value. If you need literal text rather than a changing field, delete the field and type the exact wording or date you want.

You cannot find Header & Footer or cannot edit the control. Make sure the workbook is open in the Excel desktop app and that you have selected a worksheet, not a chart sheet. On a small screen, maximize the window or expand the ribbon. If the file is read-only or protected, you may need permission to edit it or to save an editable copy. Excel for the web has a more limited set of page-layout editing controls; use Excel for Microsoft 365 on Windows or Mac when the command is missing.

Frequently Asked Questions

Does an Excel header appear on every printed page?
Yes. A worksheet header is designed to repeat on the printed pages produced from that worksheet. It is separate from the cell grid and does not become a new row in your data.

How do I add column headings instead of a print header?
Enter labels such as Name, Date, or Total in cells at the top of the data, usually in the first row. If you need those labels repeated at the top of every printed page, use Page Layout > Print Titles and set the rows to repeat at top. That feature repeats worksheet rows; it is different from a page header.

Can I add a page number to the header?
Yes. Click the header section, choose Header & Footer > Page Number, and add any wording around the field. To show a total as well, insert Number of Pages too. Confirm the numbering in print preview.

Why can I not see the header while editing cells?
Normal view focuses on worksheet cells and may not display the header. Switch to Page Layout view or open File > Print to see how it will appear on paper. The header remains saved even when it is not shown in Normal view.

Can I use a different header on the first page?
Yes. While editing the header, select Different First Page on the Header & Footer tab. Excel then provides a separate first-page header, which is useful for a cover page. Check both the first and following pages in preview because the first page can have different content or be left blank.

Will the header be visible in an exported PDF?
It should appear if the PDF is created from Excel’s print output or export settings that preserve the worksheet page layout. Check File > Print or the PDF preview before sharing. A PDF made by copying cell contents rather than exporting the page layout may not include headers.

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.