Most people open Excel to crunch numbers — and never think about what shows up on the printed page until a manager asks for a hard copy. That's usually when the missing page numbers, the absent file path, and the blank space at the bottom of the sheet become a problem.
Adding a footer in Excel is a five-minute fix, but the menu is buried under a few clicks and the behaviour shifts depending on which view you start from. This guide walks through every reliable method, the quirks to watch for, and the small habits that turn a spreadsheet print job into something that actually looks professional.
A footer sits at the bottom of every printed page. It usually carries the page number, the date, the workbook name, or a custom label — anything you want repeated on each sheet without retyping it. Excel keeps footers separate from the cell grid, so they don't appear in Normal view. You only see them once you switch to Page Layout view or Print Preview, which is the first thing most beginners miss.
Two main routes exist. The Page Layout view route is visual: you click directly into the footer area and type. The Page Setup dialog route is older but still useful for batch edits across multiple sheets or when you want precise control over fonts and alignment. Both push the same data into the workbook, but they expose different options, and knowing when to switch between them saves time on long reports.
Open your workbook, click the View tab on the ribbon, then click Page Layout. The screen redraws to show your sheet as it will print, with a ruler at the top and grey margins around each page. Scroll to the bottom and you'll see a strip labelled Click to add footer split into three boxes — left, centre, and right. Click any box and start typing. A new Header & Footer contextual tab appears on the ribbon as soon as you click inside.
That contextual tab is where the real work happens. It carries buttons for Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, Sheet Name, and Picture. Each button drops a code into the footer — &[Page], &[Date], &[File], and so on. The codes look strange in edit mode but render correctly once you click outside the footer or print the page.
Want page numbers in the centre and your company name on the right? Click the centre box, hit the Page Number button. Then click the right box and type the company name. Click outside the footer to commit. Switch back to Normal view via the View tab when you're done — your footer is saved with the workbook.
If you prefer the ribbon's Insert tab, click Insert > Text group > Header & Footer. Excel jumps straight into Page Layout view with the cursor parked in the header area. Scroll down to reach the footer strip and you're in the same edit mode as Method 1. This route is faster if you're already adding text boxes or images and don't want to leave the Insert tab.
The Insert tab approach is the one most users learn first because the Header & Footer button is right there in plain sight. The trade-off is that it lands you in the header, not the footer, so you do a quick scroll before you can type. For workbooks with one or two sheets this is fine; for anything bigger, Page Layout view gives a better overview.
The most visual route — see the footer as you build it.
Fast access from the main ribbon — lands in the header by default.
Classic dialog with Custom Footer dialog for fine control.
The classic Page Setup dialog still exists and offers options the ribbon hides. Click Page Layout tab > click the tiny arrow in the bottom-right corner of the Page Setup group. The Page Setup dialog opens. Click the Header/Footer tab. You'll see a preview area at the top and two buttons: Custom Header and Custom Footer. Click Custom Footer.
A second dialog opens with three text fields — left, centre, right — and a row of icons above them. The icons map to the same codes as Page Layout view but with text labels on hover: page number, total pages, date, time, path, file name, sheet name, picture, format picture, and format text.
This dialog is the only place you can hit the format text icon (capital A) to set font, size, bold, italic, and underline for footer text. The ribbon version forces you to select the text first and use the regular Home tab — which doesn't always behave the same way.
Once you've built the footer, click OK twice. The footer applies to the current sheet only unless you group sheets first. To apply the same footer to every sheet in the workbook, hold Ctrl, click each sheet tab to group them, then open Page Setup. Any change you make now writes to every grouped sheet.
&[Page] — Current page number, e.g. 3
&[Pages] — Total pages in the print job, e.g. 12
Combined: Type Page &[Page] of &[Pages] to render Page 3 of 12. Most common footer pattern in business reports.
&[Date] — Today's date in the system short format.
&[Time] — Current time when the page prints.
Excel uses the date and time at the moment of printing, so reprinting a workbook months later shows the new date, not the date it was first created. Type the date manually if you need a fixed value.
&[File] — Workbook file name (e.g. Q1-Report.xlsx).
&[Path] — Full directory path plus file name.
&[Tab] — Active sheet name (e.g. Summary). The Path code is useful for shared network workbooks where readers may want to locate the source file.
&[Picture] — Inserts an image; choose from file, Bing, or OneDrive.
Format Picture — Adjust size, brightness, contrast.
Pictures don't render in the footer edit view — only the code shows. Check Print Preview to confirm logos sit correctly within the print margin.
Excel's footer codes look cryptic but follow a simple pattern: an ampersand followed by a keyword in square brackets. Knowing them lets you build a footer without clicking each button. &[Page] prints the current page number. &[Pages] prints the total page count — pair them as Page &[Page] of &[Pages] for the familiar "Page 3 of 12" format. &[Date] prints today's date using your system's short date format. &[Time] prints the time. &[File] prints the workbook file name; &[Path] prints the full file path; &[Tab] prints the active sheet name.
You can mix codes with plain text freely. A footer reading Prepared by Finance — &[Date] — Page &[Page] renders as Prepared by Finance — 14/05/2026 — Page 1 on the first printed sheet. Spaces, dashes, and pipes between codes are preserved exactly. If you need a literal ampersand in the footer text — say, "Sales & Marketing" — type two ampersands (&&) and Excel renders just one. This is a classic gotcha that trips up beginners writing department names.
A company logo in the footer reinforces branding on every printed page. In Page Layout view, click the footer box, then click Picture on the Header & Footer contextual tab. Excel asks where the image lives — pick From File, From Bing, or OneDrive. Once selected, the image inserts as &[Picture] code.
Images don't appear in the footer edit area; you only see the code. To preview the result, click outside the footer or switch to Print Preview (Ctrl + P). If the image is too large, click back into the footer and use the Format Picture button on the contextual tab. A dialog opens with size, scale, brightness, and contrast options. Keep logos under 1 cm in height — anything larger eats into your print area and makes the page look unbalanced.
One quirk: Excel scales pictures based on the print area, not the screen. A 200 × 200 px logo that looks fine in Page Layout view may print much smaller on letter-size paper. Always run a test print or check Print Preview at 100% zoom before sending the file to a printer.
Excel supports two flavours of conditional footer: Different First Page and Different Odd & Even Pages. Both live on the Header & Footer contextual tab as checkboxes once you're editing a footer. Different First Page lets you skip the footer on page one — useful for cover pages where a page number would look odd. Tick the box, then go back and edit the first-page footer separately. Page 1 stays blank or carries unique text while pages 2 onward show the standard footer.
Different Odd & Even Pages is the trick magazines and books use: page numbers on the outside edge, chapter title on the inside. Tick the box, then edit the odd-page footer (page number right) and even-page footer (page number left) separately. For internal company reports, most people don't need this — but if you're producing a printed booklet or training manual, it's the difference between amateur and professional layout.
Best for: Single-sheet edits and visual users who want to see footer placement live.
Strengths: Drag-and-drop feel, immediate preview, contextual ribbon tab with one-click codes.
Limits: Harder to format text precisely; font dialog requires text selection plus Home tab.
Best for: Power users, batch edits across grouped sheets, and precise font control.
Strengths: Format text dialog inside Custom Footer, Different First Page and Odd/Even toggles in one place.
Limits: No live preview while editing — you commit changes and check Print Preview separately.
Always preview before printing. Press Ctrl + P or click File > Print. The right side of the screen shows a live preview of page one. Use the page navigation arrows at the bottom to flip through every page and check the footer renders correctly. Pay attention to two things: the footer text fits inside the print margins, and the page numbers increment properly. If your footer is cut off, return to Page Layout view and either shorten the text or adjust margins via Page Layout > Margins.
Page Setup also exposes a Scale to Fit option that shrinks the print to a chosen number of pages. Excel scales the footer along with the cells, so a footer that renders fine at 100% scale may turn into a tiny strip if you scale down to 70%. Watch for this when you're trying to squeeze a wide report onto fewer pages. The fix is usually to reduce the footer text, switch to a smaller font, or accept that the report needs more pages.
One more habit: save the workbook after editing the footer. Excel saves footers as part of the workbook, but if you close without saving you lose them. The Ctrl + S keystroke costs nothing and saves a reprint later.
To wipe a footer entirely, open Page Layout view, click into each footer box, and press Delete. All three boxes — left, centre, right — need to be cleared individually. Alternatively, open Page Setup > Header/Footer tab and choose (none) from the Footer dropdown at the top of the dialog. This nukes every section at once and is faster for sheets with cluttered footers.
Editing is similar — click in, change the text, click out. The change applies immediately to the current sheet. If you grouped sheets earlier, the edit propagates to every sheet in the group. Always check the sheet tabs at the bottom of the workbook: grouped tabs share a white background, ungrouped tabs are grey. Forgetting to ungroup is a classic mistake that leaves identical footers on sheets where you wanted them to differ.
For more practical drills on this kind of workbook navigation, run through our how to add in Excel guide and the insert a page break in Excel walkthrough. Both touch the same Page Layout tab where footers live.
Build one master footer — date, file name, page numbers — and copy it into every workbook. Consistency makes printouts easier to file and audit.
Hold Ctrl, click tabs, then edit the footer once. Saves time on workbooks with five or more sheets that need identical print layouts.
PDF output catches scaling and font-size issues before you waste paper. File > Print > Save as PDF works on Windows and Mac.
Excel Online — the browser version — supports footers but with a stripped-down interface. Click Insert > Header & Footer. The footer panel slides in from the right. You get the same three-box layout, the standard codes (page number, file name, date), and a save button. What you don't get is full image support, custom margins, or the Different Odd & Even Pages toggle. For most quick edits, the web version is fine; for serious print layouts, open the file in desktop Excel.
The mobile apps for iOS and Android are more limited. You can view footers, but editing requires opening the file in Excel for the web or the desktop app. If you find yourself fighting with footers on a phone, save the file and finish the layout work on a laptop. This is one of those situations where the desktop tool still has a real edge over the mobile experience — the print-related features simply have too many sub-options to fit on a small screen.
To keep building Excel print-and-layout skills, try our Excel hotkeys reference and the how to input formulas in Excel guide. Quick wins compound — every shortcut you learn shaves seconds off the next report.
The fastest way to lock in footer skills is to print a few practice sheets. Open any workbook, add a centred page number, a left-aligned date, and a right-aligned file name. Print to PDF (File > Print > Save as PDF) and open the PDF to verify everything sits where you expected. Repeat with grouped sheets, then with Different First Page enabled, and finally with an image in the footer. Twenty minutes of this kind of drill replaces hours of guessing on a real report.
Three mistakes show up over and over. First, editing the footer on one sheet and assuming it applies to all sheets — it doesn't unless you group them. Second, using a font size that looks fine on screen but prints too small to read; aim for 10–11 points minimum. Third, forgetting the double-ampersand rule and ending up with mangled text like "Sales Marketing" instead of "Sales & Marketing". None of these break the file — they just make the print look careless.
Once footers are second nature, the rest of Excel's print layout becomes much easier. Page breaks, print areas, margins, and headers all use the same dialogs and the same set of codes. Learn the footer well and you've effectively learned the header too. From there, working through a structured Excel practice test PDF or one of the timed quizzes below will sharpen the rest of your spreadsheet workflow.