To add the same printable header to every worksheet in an Excel workbook, select or group the worksheet tabs, then open Page Layout > Page Setup and set the header in the Header/Footer tab. The change will apply to the grouped sheets. This adds a header to printed pages or print previews; it does not put text in the first row of cells.
Before you start, decide what the header should say and whether it belongs on the left, in the center, or on the right. You can use ordinary text, such as a report name, or insert automatic fields such as the page number, date, workbook name, or worksheet name. The steps below are for Microsoft Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook saved in a format that supports the feature, such as .xlsx or .xlsm.
- Access to the worksheet tabs you want to update. If a worksheet is hidden, you may need to unhide it before you can select it as part of a group.
- Your header text, if you plan to use fixed wording. You do not need to prepare anything if you only want automatic fields such as a page number.
- Excel desktop for the most reliable access to the full Page Setup controls. If Excel for the web does not show the Header/Footer controls, choose Open in Desktop App.
Step-by-Step
- Open the workbook and identify the worksheets. Look at the tabs along the bottom of the Excel window. Decide whether you mean every worksheet in the workbook or only a particular group. A workbook can also contain chart sheets, which are not ordinary worksheets and do not have the same cell grid or header setup.
- Select the worksheets you want to update. To select every worksheet, right-click any worksheet tab and choose Select All Sheets. To select a consecutive range, click the first tab, hold Shift, and click the last tab. To select individual, nonadjacent tabs, hold Ctrl while clicking each tab. On a Mac, use Command-click for nonadjacent tabs and Shift-click for a range. Selected tabs usually appear highlighted, and Excel may show [Group] in the title bar.
- Confirm the selection before editing. Grouping is useful because many page setup changes then apply to all selected worksheets. Check that the tabs you intended are selected and that you have not included an unrelated sheet. Avoid changing cell values while sheets are grouped: ordinary edits can be repeated across every selected worksheet, which may overwrite data.
- Open the Page Setup dialog. Select the Page Layout tab on the ribbon. In the Page Setup group, click the small dialog launcher at the lower-right corner. This opens the Page Setup window. If you do not see the launcher, expand the Excel window or look for the Page Setup group on the ribbon.
- Choose the Header/Footer tab. In Page Setup, select Header/Footer. You can pick a built-in header from the Header list, or choose Custom Header to control its placement and content. For a consistent result across sheets, use the same option while the intended tabs remain grouped.
- Build the header in the section you want. In the Custom Header window, click the Left section, Center section, or Right section, then type your text. For example, enter Quarterly Sales Report in the center section. You can also use the available buttons to insert a page number, total number of pages, date, time, file path, file name, worksheet name, or a picture. Automatic fields are useful when each sheet should identify itself or when printed pages need numbering.
- Apply and close the dialogs. Select OK to close Custom Header, then select OK again in Page Setup. Excel applies the page setup change to the grouped worksheets. If you chose a built-in header instead, select it from the Header list and confirm with OK.
- Ungroup the worksheets immediately. Right-click one of the selected tabs and choose Ungroup Sheets. You can also click a worksheet tab that is not in the group, if one is available. Check that [Group] is no longer shown in the title bar. This prevents later edits from being unintentionally copied to multiple sheets.
- Preview the printed result. Choose File > Print, or press Ctrl+P on Windows; on a Mac, use Command+P. Review the preview for each worksheet you plan to print. Check that the header is visible, correctly positioned, and not cut off, then return to the workbook if you need to adjust it.
A header is part of a worksheet’s page setup, so you may need to check the print settings separately for sheets with different paper sizes, margins, or scaling. A long header can fit on one worksheet but be clipped on another if the printable width differs.
Common Mistakes
- Confusing a print header with a row of data. A header set through Page Setup appears in print preview and on printed pages. It does not appear in the worksheet grid as a cell value, and it is not a replacement for a column-heading row. If you want text visible while scrolling through the workbook, enter it in cells instead.
- Forgetting to group the sheets first. If only one tab is active when you set the header, only that worksheet is updated. Select the intended tabs before opening Page Setup, then verify the result on more than one sheet.
- Leaving sheets grouped. Excel permits group editing, but ordinary actions such as typing into a cell, deleting a range, or changing formatting may affect every grouped sheet. Ungroup as soon as the shared page setup change is finished.
- Expecting the header to show in Normal view. Normal worksheet view mainly shows cell contents. Use File > Print or switch to View > Page Layout to inspect headers. The print preview is the clearest final check.
- Using too much text or the wrong section. A long header may be truncated or crowd the page. Text placed in the left section will not be centered just because the page is centered; use the center section when you want a centered header.
- Assuming a header repeats as a frozen row. A page header is positioned in the print margin, not in the worksheet body. To repeat column headings at the top of each printed page, use Page Layout > Print Titles instead. That setting is separate from a header.
Tips
- Use the built-in fields for details that change. Insert Sheet Name when each printed sheet needs its own label, or File Name when readers need to identify the workbook. Page Number and Number of Pages fields are handy for multi-page printouts. These fields update automatically rather than relying on text you have to maintain.
- Keep fixed wording concise. A short report title, department name, or confidentiality label is less likely to be clipped. If you want a title on every printed page, place it in a header rather than repeating it manually in worksheet rows.
- Use formatting sparingly. The Custom Header dialog includes a font-formatting control. You can change the header font or size, but check the print preview after doing so. Large or bold text can take up more room and may affect the space available for the worksheet body.
- Check page layout differences. A sheet printed in landscape orientation may have more horizontal room than one printed in portrait. If one header contains a long file path or report name, check it on both layouts and shorten or reposition it if needed.
- Make a deliberate selection for future edits. When you only want to change a few worksheets, select those tabs rather than using Select All Sheets. This avoids changing a sheet that has a different purpose or print design.
- Save after confirming the preview. Header and footer settings are stored with the workbook. Save the file after checking the results so the shared setup is retained the next time you open it.
Troubleshooting
The header appears on only one sheet. The sheets probably were not grouped when you applied the setting, or the sheet you checked was not selected. Select the tabs that need the header, reopen Page Layout > Page Setup > Header/Footer, apply the setting, and preview each sheet. If you want all worksheets, use Select All Sheets from a worksheet tab’s context menu.
The header is missing from the printout. First check File > Print and confirm that you are previewing the worksheet with the header. If the preview is blank, return to the Header/Footer tab and confirm that a built-in or custom header is selected. Also check that you did not enter the text in a section other than the one you intended. If the header appears on screen but not on paper, check the printer’s printable area and the worksheet’s margins.
The text is cut off or overlaps other content. Reopen Custom Header and shorten the text, move it to another section, or reduce its font size. Then inspect the preview at the same paper size and orientation you intend to print. A header can also look crowded when it contains a long file path alongside other text.
The header is visible in preview but not in the worksheet grid. This is expected. Headers are print-page elements rather than cell contents. Use Page Layout view or Print Preview to see them; if the words must be visible on screen in Normal view, put them in worksheet cells as well.
You cannot find Header/Footer in Excel for the web. Open the workbook in the desktop app and follow the Page Layout and Page Setup steps there. The browser version’s available page setup controls can differ, so do not assume a missing control means the workbook has no header setting.
Unexpected edits are appearing on several tabs. The worksheets are still grouped. Right-click a selected tab and choose Ungroup Sheets, then review the affected sheets and undo recent changes if appropriate. Ungrouping stops future group edits but does not automatically reverse edits already made.
Frequently Asked Questions
Does this add the header to every page of every worksheet?
It adds a header setting to each worksheet you selected. Excel prints that worksheet header on its pages, subject to the sheet’s page setup and print settings. Preview multi-page sheets to confirm the result.
Can each sheet show its own name in the header?
Yes. While the worksheets are grouped, choose Custom Header and use the Insert Sheet Name button in the section where you want the label. The field displays each worksheet’s name on its own printed pages.
Will the header show at the top of the screen while I scroll?
No. A page header is for printed pages and print preview, not a fixed on-screen row. Put the text in a worksheet row if it must remain visible in the grid, or use View > Freeze Panes to keep an existing row visible while scrolling.
How do I put column headings at the top of every printed page?
Use Page Layout > Print Titles and set the rows to repeat at the top. This repeats worksheet rows during printing; it is different from adding a page header through the Header/Footer tab.
Can I use a different header on one worksheet later?
Yes. Ungroup the sheets, select only the worksheet to change, and edit its header through Page Layout > Page Setup > Header/Footer. Check the preview afterward to make sure the other worksheets remain unchanged.
Related
- How to Calculate an Average in an Excel Column
- Calculate Percentage in an Excel PivotTable
- Highlight Duplicates in Excel: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Goal Seek Cell Must Contain Value: Causes and FixesExcel Goal Seek needs a formula in the Set cell and an existing value in the By changing…
- File Folder Labels in Word: How to Create ThemTo create file folder labels in Word, open the desktop app, choose Mailings > Labels, select the label…
- Conditional Formatting to Highlight Blank CellsYes. In Excel for Microsoft 365 on Windows, select the range and choose Home > Conditional Formatting >…
- How to Insert a Table of Contents in a Word DocumentTo insert a table of contents in Word, apply built-in heading styles to your section titles, click where…
- Create a Table in Excel With a Title: Step-by-StepTo create a table in Excel with a title, type the title in a row above your data,…
- Excel Remove Duplicates Shortcut Key: What to PressIn Excel for Microsoft 365 on Windows, press Alt, then A, then M to open Remove Duplicates. These…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.