How to Add a Footer to Excel
Learn to add a footer to Excel printouts with a practical, step-by-step guide for Windows and Mac. Discover what to include, how to customize footers, and best practices for consistent reports.
Adding a footer to an Excel worksheet uses the Header & Footer tools in Page Layout. Switch to Page Layout view, select Custom Footer in the Header & Footer group, and insert items like page numbers, the current date, the file name, or workbook name. Footers apply to printed output, not the on-screen grid, and work in most Windows and Mac Excel versions.
Understanding Footers in Excel
Footers are printed content that appear at the bottom of each page when you print an Excel workbook. They are different from headers, which appear at the top. A footer can include page numbers, the current date, the file name, the path, or the workbook name. Footers help readers track printed reports and maintain a consistent look across multiple sheets or documents. In 2026, Excel still uses the same print-setup approach across Windows and macOS, though navigation paths may vary slightly between platforms.
When to use footers
Footers are most useful in formal reports, financial worksheets, or audits where printed output is shared. They ensure that every page carries essential context—such as the page number, date of printing, and source workbook name—without cluttering the main data area. If you frequently export to PDF or share bound printouts, a well-designed footer saves readers time and reinforces professionalism.
What you can include in a footer
Excel allows you to place helpful, compact information in the left, center, or right sections of a footer. Typical elements include page numbers, the file name, the workbook name, and the date. Keep the content concise to avoid crowding the printed page. Because footers are part of the print setup, they do not affect how your worksheet looks on screen.
Windows vs Mac: where to find the Footer controls
On Windows, you access footers via the Page Layout tab, then Header & Footer, and finally Custom Footer. On Mac, the path is similar but labels and menus may look slightly different depending on your Office version. In both cases, the footer area is divided into Left, Center, and Right sections, allowing you to mix text with dynamic content like page numbers or dates.
Windows workflow described in narrative
To add a footer in Windows, switch to Page Layout view, click Header & Footer, then choose Custom Footer. In the Left, Center, or Right section, insert the content you want—such as, for example, the current date on the left, and page numbers on the right. After inserting, exit the header/footer area to apply the changes. You can use Print Preview to verify alignment and spacing.
Mac workflow described in narrative
On Mac, begin by selecting Page Setup or Page Layout, then choose Header & Footer and Custom Footer. Use the Left, Center, and Right sections as with Windows. Insert elements like the workbook name or file path where it makes sense for your audience. Always perform a quick Print Preview to confirm that margins, fonts, and spacing look correct.
Printing and previewing your footer
Print Preview is your best friend when working with footers. It shows exactly how each page will appear, including footer height and line breaks. If your footer appears crowded, consider shortening the text, reducing font size, or moving items to a different section. Adjust page margins if necessary so the footer doesn’t encroach on data.
Design tips and common mistakes
Keep footers succinct—think 1–3 lines, not paragraph-length text. Use consistent content across sheets to avoid dissonance in multi-page reports. Avoid long file paths; consider showing the workbook name instead. A common mistake is placing important data in the footer that would be better placed in the main body or a header.
Practical footer examples
Examples include: Left: workbook name; Center: date; Right: page number. Another practical example places the file path on the left and the page number on the right. Depending on your print settings, you can also include a brief title or section name to orient the reader.
Troubleshooting: footers not appearing or misaligned
If the footer does not appear, verify you are in a print-oriented view (Page Layout or Print Preview) and that you are editing the correct worksheet. Check your margins, scaling, and the header/footer settings. If sheets share the same footer, ensure consistent Page Setup options across all relevant sheets.
Next steps: templates and reuse
Once you’ve set a clean, effective footer, save the workbook as a template for future use. This makes it easy to replicate the same footer across new reports and ensures consistency. You can also group sheets to apply a common footer across several pages, then ungroup when you want sheet-specific differences.
Tools & Materials
- Excel installed on Windows or macOS(Any modern version supporting Header & Footer tools)
- Printer (optional)(Only needed to print; not required to edit footers)
- Sample workbook to test footer(Helps verify footer across sheets and pages)
Steps
Estimated time: 5-15 minutes
- 1
Open the workbook and switch to Page Layout view
Open the workbook you want to print and switch to Page Layout view to reveal the header/footer region. This view makes it possible to see how the footer will appear on pages when printed.
Tip: If you don’t see the footer area, switch to a printable view or adjust zoom to a larger percentage. - 2
Access the Header & Footer tools
Go to the Page Layout tab and click Header & Footer to open the area where you can edit the footer content. This is the gateway to customizing left, center, and right sections.
Tip: Keyboard shortcuts can speed this up: use the Ribbon navigation to reach the Header/Footer controls quickly. - 3
Choose a section for your content
Decide whether your content will live in the Left, Center, or Right section of the footer. Each section can hold text or dynamic content such as page numbers or dates.
Tip: Place the most important information in the section closest to where readers naturally look first on the page. - 4
Insert a footer element
Click and type or use the Insert options to add elements like page numbers, date, or the workbook name. Avoid overly long text that could crowd the page.
Tip: Keep in mind that some content is dynamic and will update automatically on each printed page. - 5
Exit the header/footer editing mode
Leave the header/footer area to apply the changes. Returning to the normal worksheet view preserves the footer for printing.
Tip: Use the normal view or a quick Print Preview to verify alignment. - 6
Preview and adjust margins
Use File > Print or the Print Preview to check how the footer appears. If needed, adjust margins or scaling to fit the footer cleanly.
Tip: Small footer adjustments can prevent content from being cut off on narrow pages. - 7
Apply across multiple sheets
If you need the same footer on several sheets, apply it in one sheet and then group additional sheets before editing others, or copy the footer settings across sheets.
Tip: Ungroup sheets before returning to individual editing to avoid unwanted changes.
People Also Ask
Can I have a different footer on the first page?
Yes. Most versions offer a First Page footer option, allowing a distinct footer on the first page while keeping the rest consistent.
Yes, you can set a different first page footer in most Excel versions.
How can I apply the same footer to all worksheets?
You can apply the footer to multiple sheets by grouping them before editing, or by applying the footer to the first sheet and duplicating settings to others.
You can group sheets to apply the same footer across them.
Does Excel Online support footers?
Footers are a print-related feature; Excel Online support varies. If you don’t see Footer options online, open the desktop app to edit them.
Footers in the online version may be limited; try the desktop app for full control.
How do I remove a footer?
Go back to the Header & Footer area and delete or clear the content in the footer sections, then exit editing mode.
To remove, clear the footer content or choose none in the footer setup.
What content can I put in a footer?
You can place page numbers, dates, file names, and workbook names in the left, center, or right sections. Keep it concise and relevant.
You can include numbers, dates, and filenames in the footer.
Will footers affect print margins?
Yes, footers take space in the printable area. If needed, adjust margins or scaling so the main data fits cleanly on the page.
Footers use printable space; adjust margins if needed.
Watch Video
The Essentials
- Footers appear on printed pages, not on-screen grids
- Use Page Layout > Header & Footer to customize
- Preview with Print Preview to verify alignment
- Keep footers concise and consistent across sheets
