Edit an Excel footer by opening Page Layout view, selecting the bottom-left, center, or right box, then changing the text.
A printed workbook looks unfinished when the bottom margin still shows an old file name, a wrong date, or no page number. The repair is knowing how to edit a footer in Excel before you save as PDF or print the sheet.
Excel footers live outside the grid, so they do not show in the normal cell view. You edit them from Page Layout view for one sheet, or from Page Setup when you need the same footer on several sheets.
Editing An Excel Footer: Print Details That Need One Pass
Editing an Excel footer starts by switching the worksheet into a print-page view, then changing the bottom footer box you want. Excel gives each footer three zones: left, center, and right.
- Select the worksheet tab that needs the footer change.
- Go to Insert > Header & Footer.
- Scroll to the bottom of the page area.
- Select the left, center, or right footer box.
- Type the new footer text, delete old text, or choose a footer item from Header & Footer > Header & Footer Elements.
- Select any worksheet cell to leave the footer area.
- Go to View > Normal when you want the regular grid back.
The new footer appears at the bottom of the page in Page Layout view and in print preview. If the footer box still shows code such as &[Page], select outside the footer area; Excel then shows the printed value.
Which Footer Box Should You Change?
The footer box to change depends on where the text should print on every page. Left is often used for file names, center for page numbers, and right for dates or prepared-by notes.
Footer text does not follow the cell alignment in the worksheet. A centered footer stays centered across the printed page even when the columns on the sheet are narrow, wide, hidden, or scaled for printing.
| Footer Need | Best Footer Zone | What To Put There |
|---|---|---|
| Page number on every page | Center | &[Page] or Page &[Page] of &[Pages] |
| Total page count | Center | &[Pages] after the page number |
| Printed date | Right | &[Date] |
| Printed time | Right | &[Time] |
| Workbook file name | Left | &[File] |
| Full file path | Left | &[Path]&[File] |
| Worksheet name | Left or right | &[Tab] |
| Logo or stamp image | Left, center, or right | Use Picture, then check print preview |
Microsoft lists both Insert > Header & Footer and the Page Setup dialog as Excel footer editing paths in its Excel headers and footers worksheet steps.
Use Page Setup For Several Sheets Or Chart Sheets
Page Setup is the better place to edit a footer when several worksheets need the same print label. Page Setup is also the path Excel uses for chart sheets and charts.
To apply one footer to more than one worksheet, select the sheet tabs first. Hold Ctrl, select each worksheet tab you want, then open Page Layout > Page Setup by selecting the small dialog launcher in the Page Setup group.
- Open the Header/Footer tab.
- Select Custom Footer.
- Select the Left section, Center section, or Right section box.
- Type text or use the buttons for page number, date, time, file path, file name, sheet name, or picture.
- Select OK, then select Print Preview or OK again.
Excel shows [Group] in the title bar while several sheets are selected. When the footer is done, select an ungrouped sheet tab or right-click a grouped tab and choose Ungroup Sheets so your next edit affects only one sheet.
Format Footer Text Without Breaking The Print Layout
Footer formatting changes the printed footer, not the worksheet cells. Select the footer text, then use the Home tab to change font, size, bold, italic, or color.
If the footer size shifts when you scale the worksheet for printing, open the footer area and clear Scale with Document on the Header & Footer tab. Leave Align with Page Margins on when the footer should line up with the sheet margins; clear it only when the footer needs its own left and right position.
A single ampersand needs special handling because Excel uses ampersands inside footer codes. To print one ampersand in footer text, type two ampersands, such as Research && Finance.
Why Does The Footer Not Show In Normal View?
Excel hides footers in Normal view because footers belong to printed pages, not cells. Use Page Layout view or Print Preview to inspect the footer before printing.
That design can make a footer feel lost after you leave the print view. The footer is still attached to the worksheet; the grid view is just not built to show page edges, page headers, or page footers.
| Footer Problem | Likely Cause | Move That Fixes It |
|---|---|---|
| Footer vanished after editing | Workbook is back in Normal view | Open View > Page Layout |
| Page number prints as code | Footer box is still active | Select a worksheet cell, then preview again |
| Footer changed on every sheet | Worksheets are still grouped | Right-click a sheet tab and choose Ungroup Sheets |
| Footer is too close to the sheet | Footer margin is too small | Open Page Layout > Margins > Custom Margins |
| Logo overlaps rows | Image is too tall for the footer area | Resize the picture or raise the footer margin |
| Date changes each time | &[Date] prints the current print date |
Type a fixed date as plain text |
Print The Sheet Only After These Footer Checks
A footer can look right in the editing box but still print poorly if margins, scaling, or grouped sheets are wrong. Run these checks before sending the workbook to a printer or PDF.
- Open File > Print and inspect the first and last page.
- Confirm the left, center, and right footer zones do not collide.
- Check that page numbers restart or continue the way the workbook needs.
- Look for
[Group]in the title bar before making more edits. - Use plain typed text for details that must never change, such as a project code or approved date.
- Use footer codes only for details that should refresh, such as file name, date, time, page number, or sheet name.
After these checks, the footer is ready for PDF export or printing. The printed pages should show the edited footer in the chosen bottom zone, with live codes turned into their page, date, file, or sheet values.
References & Sources
- Microsoft.“Headers and Footers in a Worksheet.”Lists Excel worksheet footer editing steps, Page Setup options, and footer removal steps.
- Microsoft Excel.“Microsoft Excel Official Site.”Official product page for Excel in Microsoft 365.