How to Insert a Footer in Excel Easily and Correctly

Knowing how to insert a footer in Excel is an important skill for anyone who works with spreadsheets, reports, or printed documents. A footer appears at the bottom of each printed page and is commonly used to display information such as page numbers, file names, dates, sheet names, or company details. Adding a footer helps make Excel documents look more professional, organized, and easier to reference.

This article explains different methods for inserting a footer in Excel, how to customize it, and tips for using footers effectively.

1. Table of Contents

   Toggle

   What a Footer Is in Excel

A footer is a section that appears at the bottom of a printed Excel page.

Footers are commonly used to show:

• Page numbers
• File name or worksheet name
• Date and time
• Company or author name
• Confidential or copyright notices

Footers do not appear in normal worksheet view but are visible in Page Layout and Print Preview.

2. Insert a Footer Using Page Layout View

This is the most beginner-friendly method.

To insert a footer using Page Layout:

• Open your Excel workbook
• Click the View tab
• Select Page Layout
• Scroll to the bottom of the page
• Click inside the footer area

You will see three footer sections:

• Left footer
• Center footer
• Right footer

You can type text directly into any section.

3. Add Built-In Footer Elements

Excel allows you to insert automatic elements instead of typing manually.

Available footer elements include:

• Page Number
• Number of Pages
• Current Date
• Current Time
• File Path
• File Name
• Sheet Name

To insert these:

• Click inside a footer section
• Go to the Header & Footer tab
• Choose the element you want from the ribbon

These elements update automatically when printed.

4. Insert a Footer Using the Page Setup Dialog Box

This method is useful for more control.

Steps to use Page Setup:

• Click the Page Layout tab
• Select Page Setup
• Go to the Header/Footer tab
• Choose a predefined footer or select Custom Footer
• Enter text or insert elements
• Click OK

This method works well when preparing documents for printing.

5. Customize Footer Text and Formatting

Footers can be customized to match your document style.

Customization options include:

• Changing font type and size
• Adding bold or italic text
• Combining text with page numbers
• Using different content in each section

For example:

• Left section: Company name
• Center section: Document title
• Right section: Page number

Balanced formatting improves readability.

6. Insert Page Numbers in the Footer

Page numbers are one of the most common footer uses.

To insert page numbers:

• Click the footer section
• Choose Page Number from the Header & Footer tools
• Optionally add of Total Pages

This creates formats such as “Page 1 of 5”.

7. Preview the Footer Before Printing

Always preview your footer to avoid mistakes.

To preview:

• Click File
• Select Print
• Check the footer placement at the bottom of each page

Previewing helps ensure:

• Correct alignment
• Proper spacing
• Accurate information

Make adjustments if necessary.

8. Remove or Edit an Existing Footer

Footers can be changed or removed at any time.

To remove a footer:

• Go to Page Layout View
• Click the footer area
• Delete the content

To edit:

• Click the footer section
• Modify text or elements
• Exit Page Layout view

Changes apply to all printed pages.

9. Common Footer Mistakes to Avoid

Avoid these issues when using footers:

• Overcrowding the footer with text
• Using very small fonts
• Placing sensitive information unintentionally
• Forgetting to preview before printing

Simple, clear footers work best.

10. Best Practices for Using Footers in Excel

Effective footer use improves document quality.

Best practices include:

• Keeping footer content brief
• Using consistent formatting
• Including only relevant information
• Aligning footer content properly

Professional footers enhance clarity and presentation.

Also Read: What to Do If You Can’t Start Your Car