How to Add a Footer in Microsoft Excel

Excel is used by over 750 million people worldwide — yet most of them never touch the header and footer settings. That’s a missed opportunity hiding in plain sight.

Whether you’re printing a financial report, sharing a data sheet with your team, or building a client-facing dashboard, footers make your work look polished and professional. They keep page numbers, dates, file names, and branding consistent across every printed page — without you having to type it manually.

This guide walks you through exactly how to add a footer in Microsoft Excel, customize it, and avoid the common mistakes that trip people up.

What Is a Footer in Excel and Why Does It Matter

A footer is a strip of text that appears at the bottom of every printed page in your Excel workbook. It can contain anything — your company name, a page number, today’s date, the file path, or a custom message.

Here’s why it’s worth using:

• 67% of businesses use Excel for financial reporting, and footers help ensure every printed report carries context — who created it, when, and which page the reader is on.
• Footers eliminate the guesswork when someone prints a multi-page spreadsheet and the pages get separated.
• They add a layer of professionalism that plain, unmarked printouts simply don’t have.

Excel gives you three zones in each footer — left, center, and right — so you can pack in multiple pieces of information without cluttering your actual data.

How to Add a Footer in Excel — The Quick Way

If you just need a footer fast, this is your path.

Go to the Insert tab on the ribbon. Look for the Text group on the right side. Click Header & Footer.

Excel will immediately switch into Page Layout view and open the header/footer editing area. You’ll see three clickable sections at the bottom of the page — that’s your footer.

Click the section where you want to add text (left, center, or right). Type your content. Click anywhere outside the footer area when you’re done. Go back to Normal view via the View tab.

That’s it. Your footer will appear on every printed page automatically.

How to Add a Footer Using Page Layout View

If you prefer working visually — seeing exactly where your footer sits on the page — the Page Layout view is the cleaner approach.

Click the View tab. Select Page Layout. Scroll down to the bottom of any page in your sheet. You’ll see a section that reads “Click to add footer.” Click it. You’ll see three zones appear — left, center, and right. Click the zone you want and start typing.

This method is especially useful when you’re designing footers that need to line up with specific columns or when you want to preview how everything looks before printing.

How to Add a Custom Footer in Excel

For more control over what goes into your footer, use the Page Setup dialog.

Go to Page Layout tab → click the small arrow in the bottom-right corner of the Page Setup group → select the Header/Footer tab → click Custom Footer.

A dialog box opens with three text boxes — Left, Center, and Right. You can type anything directly into these boxes. You can also use the toolbar buttons inside the dialog to insert:

• Page numbers
• Total number of pages
• Current date
• Current time
• File name
• Sheet name
• A picture (like a company logo)

To format the text, highlight it and click the font button (the A icon). You can change the font, size, bold, italic, and color right there.

Click OK when done, then OK again to close Page Setup. Your custom footer is set.

Adding Page Numbers to Your Excel Footer

Page numbers are the most common footer element — and for good reason. When your spreadsheet spans multiple pages, readers need them.

Here’s how to add page numbers:

Open Custom Footer (via Page Layout → Page Setup → Header/Footer → Custom Footer). Click the section where you want the page number. Click the Insert Page Number button (looks like a # symbol). Excel will insert &[Page]. To show it as “Page 1 of 5,” type Page before &[Page], then of, then click the Insert Number of Pages button which inserts &[Pages].

Final result looks like: Page &[Page] of &[Pages]

Click OK and you’re done. Every page will dynamically update the page number when printed.

How to Add Date and Time to Your Footer

Reports and data printouts should always carry a timestamp. That way, recipients know exactly when the data was current — especially important when 89% of organizations rely on spreadsheets for operational data that changes regularly.

In the Custom Footer dialog, click the section where you want the date. Click the Insert Date button (calendar icon) — this inserts &[Date]. To also add time, click next to it and click Insert Time — this inserts &[Time].

The date and time will update automatically each time the file is opened or printed, so you never need to update it manually.

How to Add a Footer to Multiple Sheets at Once

If your workbook has multiple sheets — say, a monthly report with tabs for each region — you can apply the same footer to all of them without repeating the steps.

Right-click any sheet tab at the bottom. Select Select All Sheets (or hold Ctrl and click each sheet you want). Now add your footer using any method above. The footer will apply to all selected sheets simultaneously.

Once done, right-click the tab again and select Ungroup Sheets so future edits don’t accidentally affect all sheets.

This saves significant time. According to Microsoft, Excel users spend an average of 17 minutes per task on repetitive formatting — this batch method cuts that down to one action.

How to Edit an Existing Footer in Excel

Already have a footer but need to update it? No need to start over.

Go to Page Layout view (View tab → Page Layout). Scroll to the bottom of the page. Click directly on the footer text you want to edit. Make your changes. Click outside when done.

Alternatively, use Page Setup → Header/Footer tab → Custom Footer and edit the content in the dialog boxes.

How to Remove a Footer in Excel

Removing a footer is just as simple as adding one.

Go to Page Layout tab → Page Setup group → click the small arrow → Header/Footer tab. In the Footer dropdown at the top, select (none). Click OK.

That clears the preset footer entirely. If you used Custom Footer, open it, select all text in each zone, delete it, and click OK.

Footer Formatting Tips That Make a Difference

A functional footer is good. A professionally formatted one is better.

Keep it concise. Footer space is limited — especially on smaller page sizes. Stick to three elements maximum.

Use the three-zone layout deliberately. A common structure: Company Name (left) | Page Number (center) | Date (right). This feels balanced and reads naturally.

Match your brand. If you’re sending the spreadsheet to clients, use your brand font and include your logo using the Insert Picture option in Custom Footer.

Test before printing. Use Print Preview (Ctrl + P) to see exactly how your footer will look. What seems fine in Page Layout view can shift slightly on paper.

Avoid long file paths in footers for external reports. The &[Path] code shows your full directory path — useful internally, but potentially confusing or sensitive for external recipients.

Common Footer Mistakes to Avoid

Mistake: Adding a footer but forgetting to check it in Print Preview. Footers can get cut off if your page margins are too small. Always check Margins under the Page Layout tab.

Mistake: Applying footer changes to one sheet when you needed all of them. Always group your sheets first when working on multi-tab workbooks.

Mistake: Using static text for the date instead of the &[Date] code. Manually typed dates don’t update — you’ll end up with old timestamps on future prints.

Mistake: Overlapping footer text. If all three zones have a lot of text, they can collide. Keep each zone short or use only two zones.

Conclusion

Adding a footer in Microsoft Excel is one of those small details that separates a sloppy printout from a polished, professional document. Whether you’re inserting a page number, a date, your company name, or a combination of all three, the process takes under two minutes once you know where to look.

Start with the Insert tab for speed, use Page Layout view for visual control, and use the Custom Footer dialog when you need full formatting power. Batch-apply to multiple sheets when working with large workbooks, and always check Print Preview before you send anything out.

Once your footers are set, they run on autopilot — updating dates, page numbers, and sheet names dynamically, every time you print.