To add the same footer to every sheet in Excel, right-click any sheet tab and choose Select All Sheets, then go to Page Layout, open the Page Setup dialog, and use Header/Footer > Custom Footer. Then ungroup the sheets.
A workbook with a dozen monthly tabs needs the same company name and page number at the bottom of every printed page, and setting each sheet one by one is slow. These steps are for Excel for Microsoft 365 and Excel 2016 to 2024 on Windows.
Group the Sheets First
Excel applies page settings to the selected sheets, so the footer only reaches every tab if every tab is selected before you open Page Setup.
- Right-click any sheet tab at the bottom of the window.
- Choose Select All Sheets. The selected tabs are highlighted and Group appears in the title bar next to the file name.

To include only some sheets, Ctrl-click each tab you want, or click the first tab and Shift-click the last to grab a run of neighboring sheets. That is handy when a workbook has twelve monthly sheets plus a lookup sheet that never gets printed.
Warning: while sheets are grouped, anything you type or delete on the active sheet happens on every sheet in the group. Don’t edit cells until you have ungrouped.
Microsoft points to the Page Setup dialog for headers and footers on more than one worksheet at a time, so this is the route to use with grouped sheets.
- With the sheets still grouped, open the Page Layout tab.
- In the Page Setup group, click the small dialog box launcher (the arrow in the group’s lower right corner).
- Open the Header/Footer tab and click Custom Footer.
- Click in the Left section, Center section or Right section box and type your text, such as the company name. Press Enter inside a box to start a second line.
- Use the buttons above the boxes to add items that change by page or file. Hover over a button to see its name.

- Click OK to close Custom Footer, check the preview strip on the Header/Footer tab, and click OK again.
A common layout is the company name on the left, the sheet name in the center and “Page 1 of 3” on the right. If you only need a standard footer, the Footer drop-down list on the Header/Footer tab usually offers ready-made choices, so you may be able to skip Custom Footer.
Ungroup the Sheets
As soon as the footer is set, release the group. Click any sheet tab that isn’t selected, or, if every sheet is selected, right-click a tab and choose Ungroup Sheets. The Group label disappears from the title bar, and from then on edits stay on the sheet you’re working in. The footer stays on all the sheets.
Footers don’t show in Normal view. Excel displays them only in Page Layout view, in Print Preview and on paper, which is why a footer can look missing when it is actually there.
- Go to File > Print.
- Under Settings, open the first list and choose the option to print the entire workbook (Print Entire Workbook on most versions) so the preview includes every sheet.
- Page through the preview and confirm the footer is at the bottom of each sheet’s pages.

You can also click Page Layout view on the status bar to see the footer while you work, then return with View > Normal.
Page Numbers, Sheet Names and Dates
The Custom Footer buttons insert codes that Excel fills in at print time. Clicking a button is safer than typing the code yourself.
| Button | Code it inserts | Prints as |
|---|---|---|
| Insert Page Number | &[Page] | 3 |
| Insert Number of Pages | &[Pages] | 12 |
| Insert Date | &[Date] | Today’s date |
| Insert Time | &[Time] | The current time |
| Insert Sheet Name | Shown in the box | The tab name, such as March |
| Insert File Name / File Path | Shown in the box | The workbook name or its full location |
For “Page 3 of 12”, type Page, click Insert Page Number, type of, then click Insert Number of Pages. The box reads Page &[Page] of &[Pages]. The Sheet Name button is the useful one for grouped sheets: one footer, but each printed page shows its own tab name.
Two traps. Excel uses the ampersand for codes, so to print a single & (as in Smith & Sons) type it twice. And page numbers follow each sheet’s own settings: if every sheet starts at page 1 when you print the workbook, check the First page number box on the Page tab of Page Setup, which you can set per sheet.
You’ll usually also see a picture button for adding a logo and a format text button for changing the font; hover over a button to confirm its name.
The Header/Footer tab of Page Setup has four checkboxes at the bottom: Different odd and even pages, Different first page, Scale with document and Align with page margins. Tick Different first page to leave the cover page bare or give it its own footer. Odd and even footers are for double-sided printing, where page numbers usually sit on the outside edge. In Page Layout view, the same options sit in the Options group of the Header & Footer tab (labeled Design in some versions).
Changes work the same way as adding: group the sheets, open Page Setup > Header/Footer, click Custom Footer and edit the boxes. To remove the footer from all of them, group the sheets, open the Footer drop-down list on the Header/Footer tab, choose (none) and click OK. Ungroup when you’re done.
- Some sheets are missing it. They weren’t in the group. Ctrl-click those tabs, open Page Setup and add the same footer.
- You can’t see the footer at all. You’re in Normal view. Use Print Preview or Page Layout view.
- Text you typed showed up on every sheet. The sheets were still grouped. Press Ctrl+Z right away, then ungroup.
- You used Page Layout view and not every sheet got the footer. Some people add the footer in Page Layout view (Insert > Header & Footer) while sheets are grouped, but Microsoft recommends the Page Setup dialog for more than one worksheet at a time. Use Page Setup for groups, and check every sheet in Print Preview.
- The footer is cut off or crowded. Long text in three sections can overlap. Shorten it, or shrink the printout as described in fitting a spreadsheet on one page.
Can Each Sheet Have a Different Footer?
Yes. Footers are stored per sheet. Apply the shared footer to the group, ungroup, then select a single sheet and change its footer in Page Setup. Or use the Sheet Name button so one footer reads differently on each tab.
Will New Sheets Get the Footer?
Not automatically. A sheet added later starts with its own page settings, so group it with one other sheet and add the footer again. Copying an existing sheet (right-click the tab > Move or Copy > Create a copy) may carry the footer along, but check it in Print Preview.
Does the Same Method Work for Headers and Print Titles?
Headers use the same Header/Footer tab with the Custom Header button. Rows that repeat at the top of each page are a different setting; see repeating rows when you print in Excel. And if by “header” you mean a title across the top of the data, that is cell formatting, covered in making an Excel header span multiple columns.
Does This Work in Excel for the Web or on a Mac?
Microsoft’s multi-sheet instructions are written for the Windows desktop app. Other versions may lay out Page Setup differently, so if you can’t find the dialog, open the workbook in the desktop app.
Microsoft’s Headers and footers in a worksheet page lists every button and option. Once the footer is in place, a quick print to PDF of the whole workbook is the fastest way to confirm every tab got it, and adding printed gridlines is a common next step for readable pages.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.