To add the same print header to every worksheet in an Excel workbook, select and group the sheets, open Page Setup, and enter the header on its Header/Footer tab. In Excel for Microsoft 365 on Windows, this applies the header to the selected sheets together. A print header appears in Page Layout view, Print Preview, and on printed pages; it does not add text to the worksheet grid.
Before you start, decide what you mean by a header. A print header is text or content in the top margin of a printed page. A row of column labels, such as Date, Name, and Amount, is worksheet data; it can be repeated at the top of each printed page using Print Titles instead. The steps below cover print headers first, then explain the difference.
What You’ll Need
- An Excel workbook saved in a format that supports worksheets, such as .xlsx.
- At least two worksheets where you want the same print header.
- The header text you want to use, such as a report name, department, or date range.
- Permission to edit the workbook and its sheet structure. If the workbook structure is protected, you may need its owner to unlock it before grouping sheets.
Step-by-Step
- Save a working copy. Use File > Save As if you want to keep an untouched original. Grouping sheets lets one Page Setup change affect several worksheets, so a separate copy is a useful safeguard when the workbook contains important print settings.
- Show the worksheet tabs. If you cannot see the sheet tabs at the bottom of Excel, widen the Excel window or use the horizontal scrollbar controls to expose them. If the tabs are hidden, right-click a visible sheet tab, choose Unhide, select the required sheet, and choose OK. A hidden worksheet cannot be included in a selection until it is unhidden. You can hide it again after setting its header.
- Select all sheets that need the header. Right-click any worksheet tab and choose Select All Sheets to group the workbook’s visible worksheets. To affect only some sheets, click the first tab, hold Ctrl on Windows, and click each additional tab. For a continuous range of tabs, click the first tab, hold Shift, and click the last one. Selected tabs usually appear highlighted. Check the status or title area for the word Group, if shown, and be careful not to include sheets that should keep different headers.
- Open the Page Setup dialog. With the sheets still grouped, select the Page Layout tab. In the Page Setup group, click the small dialog box launcher at its lower-right corner. In the dialog, select the Header/Footer tab. This route gives you access to header settings for the selected worksheets together. Do not choose the Insert tab’s Header & Footer command for this grouped-sheet workflow; use the Page Setup dialog so you can set the shared header across the group.
- Choose a preset or create your own header. In the Header/Footer tab, open the Header list and pick a built-in option if it suits your needs. For custom text or different left, center, and right content, click Custom Header. In the Custom Header dialog, click the Left section, Center section, or Right section, then type your text in the box. Use the dialog’s buttons to insert items such as page number, total pages, date, time, file name, or sheet name. Click OK when the header is arranged, then click OK again to close Page Setup.
- Ungroup the worksheets immediately. Right-click one of the selected sheet tabs and choose Ungroup Sheets. Alternatively, click a sheet tab that is not part of the group, if one is available. If every visible sheet was selected, right-click a tab and choose Ungroup Sheets. Confirm that only one tab is selected before you continue editing. While sheets are grouped, ordinary changes to cells, formatting, or layout may be applied to every selected sheet, not just the one currently displayed.
- Check the result on more than one sheet. Select a worksheet and choose View > Page Layout to see its header above the grid. Then select another worksheet that should share it and check again. You can also open File > Print to inspect Print Preview. Excel may show a blank header area in Normal view; that does not mean the header failed. Return to View > Normal when you want the usual worksheet grid.
- Print or export a sample page. In File > Print, review the preview for each relevant worksheet. If the workbook has different page orientations, margins, or scaling, check at least one sheet of each type. You can print a single page or save a PDF for a final visual check before producing a complete report. A header can be present but appear clipped if the top margin is too small or the content is too wide.
To repeat column headings instead: Ungroup the sheets first. Select the worksheet, go to Page Layout > Print Titles, and on the Sheet tab set Rows to repeat at top, such as $1:$1. This repeats worksheet rows on printed pages; it is not the same as a header in the top margin. Print Titles settings are configured per worksheet, so you may need to set them individually.
Common Mistakes
- Confusing a print header with a heading row. A print header sits in the margin outside the cell grid. If you want labels such as Product or Quantity to repeat above the table on every printed page, use Print Titles. If you want those labels visible while scrolling, freeze the row with View > Freeze Panes instead.
- Forgetting to group the sheets first. If you open Page Setup with only one sheet selected, you may change only that sheet. Select the intended tabs before opening the dialog, then verify the outcome on multiple sheets.
- Leaving sheets grouped. This is one of the easiest mistakes to miss. Typing in a cell or deleting content while sheets are grouped can repeat the edit across them. Ungroup as soon as the shared Page Setup change is complete.
- Assuming new sheets inherit the header. The settings apply to sheets selected when you made the change. A worksheet created later may not have the same header, so check it and apply the settings if needed.
- Using overly long or detailed content. A long title, large font, or multiple header elements can overlap or be clipped, especially on narrow portrait pages. Keep the text concise and preview sheets with different layouts.
- Expecting to see the header in Normal view. Print headers are not cell contents. Check in Page Layout view or Print Preview rather than entering text into the grid to try to make the margin header appear.
Tips
- Use the three sections deliberately. Put a short report name in the center, a department or project label on the left, and page numbering on the right. Keeping content separated makes it easier to read and reduces the chance of overlap.
- Use Excel’s built-in header elements for changing information. In Custom Header, the date and time buttons insert fields that update when Excel prints or previews the sheet. The page number field is more useful than typing a fixed number because each printed page can show its own number.
- Match the header to the print layout. A header that fits on a landscape page may be crowded on a portrait page. Use Print Preview to check both orientations and consider shortening the text or moving an item to another section.
- Keep an inventory of exceptions. If one worksheet needs a different title, do not group it with the others when you apply the common header. Set its header separately afterward, and note the exception so a later workbook-wide update does not overwrite it.
- Check print settings as well as the header. Paper size, orientation, margins, and scaling affect the available space. The Page Layout tab lets you review these settings, while File > Print shows the final page arrangement.
Troubleshooting
The header appears on only one sheet: The other sheets may not have been selected when you opened Page Setup, or they may not have been included in the group. Select the missing sheet tabs together and apply the header again through Page Layout > Page Setup dialog launcher > Header/Footer. Then ungroup and verify each sheet in Page Layout view.
I cannot group or unhide a sheet: The workbook structure may be protected. Check Review for the Protect Workbook command or ask the workbook owner to remove the structure protection. Sheet protection and workbook-structure protection are different: sheet protection restricts edits within a sheet, while structure protection can block actions such as selecting, moving, or unhiding sheets. Do not remove protection unless you have permission.
The header is missing from Print Preview: Confirm that the sheet has a header selected in Page Setup, then check that you are previewing the correct worksheet. If the chosen header is blank or contains only fields that are not obvious in the current view, use Custom Header to inspect its sections. Also verify that the header is not being hidden by a very small top margin or an unusual page setup.
The text is cut off or overlaps: Return to Custom Header and shorten the text, reduce its font size with the formatting controls, or move content between left, center, and right sections. Then review Page Layout and Print Preview again. If the header only fails on one sheet, that sheet may have a different paper size, orientation, or margin setting.
The tabs show Group after I thought I finished: Right-click a selected tab and choose Ungroup Sheets. If you are uncertain whether a group is still active, click a single tab and confirm that the other tabs are no longer selected before making cell or formatting edits.
Frequently Asked Questions
Does this add a header to every sheet, including hidden sheets?
Select All Sheets applies the change to visible worksheets. Hidden sheets must be unhidden before you can select them as part of the group. After applying and checking the header, you can hide those sheets again. Remember that a new worksheet added later may need the header set separately.
Will the header show on the worksheet while I enter data?
Usually not in Normal view, because a print header belongs to the page layout rather than to worksheet cells. Choose View > Page Layout to see it above the grid, or use File > Print to inspect the printed result. Do not type the header into row 1 unless you actually want it to be cell content.
Can I put a logo in the header?
Yes. In Custom Header, select the left, center, or right section and use the Insert Picture button to choose an image. Excel may display a picture placeholder in the dialog; use Print Preview or Page Layout view to check the actual result. A large logo can take up header space, so resize or reposition it if it crowds the text.
Can each sheet have a different header?
Yes. Select one worksheet at a time and set its header in Page Layout > Page Setup > Header/Footer. You can also apply one common header to a group first, then change exceptions individually after ungrouping. Check the sheets separately so a later grouped change does not replace an intentional difference.
How do I remove the header from all selected sheets?
Group the sheets that contain the header, open Page Layout > Page Setup > Header/Footer, and choose (none) from the Header list. Click OK, ungroup the sheets, and inspect Print Preview. If some sheets should keep their headers, exclude them from the group or restore their individual settings afterward.
Does the same method work in Excel for Mac or Excel for the web?
Excel for Mac has similar Page Layout and Page Setup controls, though the dialog layout and tab-selection gestures can differ; use Command-click rather than Ctrl-click to select separate tabs on a Mac. Excel for the web has more limited page setup options, and its interface can vary. For grouped-sheet header setup, open the workbook in the desktop Excel app if the required Page Setup controls are unavailable.
Related
- Insert a Yes/No Dropdown in Excel: A Step-by-Step Guide
- How to Insert a Row in Excel on a Laptop, Step by Step
- Insert Rows in Excel Multiple Times: 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
- Insert Entire Row in Excel: Shortcut and AlternativesIn Excel for Microsoft 365 on Windows, select any cell in the row and press Shift+Space to select…
- Schedule an Email in Outlook: Steps and TipsTo schedule an email in Outlook, write the message, open the menu beside Send, choose Schedule send, and…
- Custom Sort in Google Sheets: Steps, Rules, and ExamplesTo custom-sort Google Sheets data, select the full table, choose Data > Sort range > Advanced range sorting…
- Invoice Template Excel South Africa: VAT and SetupFor an invoice template in Excel for South Africa, create a workbook with supplier and customer details, a…
- Text Excel Format: How It Works and When to Use ItIn Excel, Text format tells a cell to treat what you enter as text rather than interpreting it…
- Excel Merge Cell Shortcut: Keys and Safe AlternativesIn Excel for Microsoft 365 on Windows, press Alt, H, M, C in sequence to merge the selected…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.