WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Insert Footer in Excel

July 25, 2022
2.7K Views

In Excel spreadsheets, you can also insert footer in Excel to place dates, names, etc. Another option is to use the Page Setup dialog box to insert the headings you need into your text box. In this way, you can identify your work so that the other person considers the purpose.

It is always necessary to have a good title in all your content. In this way, you will not waste more time. By insert footer in excel, you will be able to identify them, and you will see that it will be much easier to find your documents, both for you and other users. Headers are made up of footer, page number, date, time, sheet name, etc.

Part 1 How to Insert Footer in Excel?

1. Adding a Worksheet Footer

You can add or change the headings with the Excel program's page layouts. Insert footer in Excel, it will not take much time, and you will also be able to organize your work more easily.

Step 1: Go to the spreadsheet and click where you want to place the header or footer.

Step 2: In the Insert tab, go to the text, and you will see Header and Footer. Click to add it (Excel will show you in Page Layout, the spreadsheet preview).

Step 3: You can add or edit the header or footer by clicking the left, right, and center header text box.

To close headers or footers, you can click anywhere in the text box or make changes without saving press Esc.

My User Experience:

While following these steps, I found the customization options to be quite versatile, allowing me to tailor the footer to my specific needs. The ability to include dynamic content like page numbers and dates was particularly useful. However, I did encounter a slight challenge in adjusting footer margins, which required a bit of trial and error to get just right. Overall, this method proved highly effective in enhancing the visual appeal of my spreadsheets.

logo

2. Inserting a Predefined Footer in Excel

Excel offers a variety of predefined footer options that can save you time and effort in creating a professional footer. Let's explore how to easily insert one of these predefined footers into your spreadsheet.

1. Navigate to the "Insert" tab. Subsequently, click on the "Text" section, followed by selecting the "Header & Footer" option.

Inserting a Predefined Footer  excel

source: excel options


2. Within this tab, you have the liberty to pick any desired element to serve as your header. For instance, should you opt for the "Number of Pages" element, clicking on it will promptly introduce it as a header within your worksheet.

Inserting a Predefined Footer  excel

source: excel options


3. You can readily select the predefined "Header and Footer" elements by utilizing the dedicated "Header" and "Footer" options. Upon selecting either of these, a menu will appear, displaying a catalog of preformatted elements to choose from.

Inserting a Predefined Footer  excel

source: excel options


4. Should you wish to preview the appearance of your selected "Header" and "Footer" components, simply click anywhere on the sheet.

My User Experience:

Inserting a predefined footer proved to be a quick and efficient way to add professionalism to my Excel documents. The variety of available options saved me the hassle of customizing from scratch. However, I realized that while predefined footers are convenient, they might not always perfectly match the unique requirements of every document. It's crucial to choose an option that aligns with your content's purpose.

logo

3. Changing or Deleting a Page Footer

Imagine you learned to make a footer but didn’t learn how to change or delete it. What if you make a mistake while making the page footer? In that situation, you can always change or delete a page footer. Excel software is flexible and efficient, allowing easy alteration and deletion of footers. Altering and deleting the footer is a great feature allowed by Excel. Imagine that Excel didn’t provide these features. What would you do in that situation? Copy and paste the data and make a new worksheet page. The question is how to change or delete the page footer in Excel. A step-by-step guide will enable you to quickly change or delete the page footer. Please read the steps carefully, see the screenshots, and apply them to learn this technique.

Change or delete the header or footer from the first page.

Here’s how you can change or delete the header or footer from the first or main page of your worksheet in Excel:

Step 1: The first thing to do is to double-click the first-page header or footer area.

Step 2: Check the Different First Page to see whether it’s selected or not. If it’s not selected, then select the Different First Page.

Step 3: This way, the content of the footer or header on the first page is removed, and a new different first page is selected.

Step 4: Now, all you need to do is to add data, I.e., content, to your new footer or header.

Step 5: Now close the header or footer by pressing the Esc or Close Header or Footer buttons.

4. Change or delete a header or footer from another single page

Here’s how to change or delete a header or footer from another page.

Step 1: Go to that single page or create a new page where you want your page Footer or Header to be.

Step 2: Navigate to the Layouts, then break, and choose the next page to create a section break.

Step 3: Now double-click the header and footer area to open the Header and Footer tab.

Step 4: Now turn off the Link to Previous option to prevent it from linking to the previous section. Select the header or footer and either choose the remove header or remove footer option.

Step 5: Add or edit the contents of the footer or header.  Close the header and footer section using the Close button or Esc.

My User Experience:

I found this method particularly handy when I needed to make minor adjustments to a specific page's header content. The step-by-step approach made it easy to navigate and edit the header or footer without altering the rest of the document. However, it's important to remember that this technique is best suited for isolated changes; if you need consistent modifications across multiple pages, other methods might be more efficient.

logo

5: Printing with Different First Page Headers or Footers in Excel

Excel provides the flexibility to display distinct headers or footers on the first page of your document compared to subsequent pages. This feature is particularly useful when you want to include additional information on the initial page while maintaining a consistent format for the rest of the document.

1. To initiate the process, head to the "View" tab within the Excel menu. Next, select "Page Layout."

2. At the top, you'll notice the prompt "Click to Add Header" and at the bottom, "Click to Add Footer" Opt for your desired option. If you require a header, click on the header section; if it's a footer you need, select the footer.

Printing with Different First Page excel

source: excel options


3. The design segment is now visible. Click on the "Different First Page" option (ensure to mark the checkbox indicating a different first page).

Printing with Different First Page excel

source: excel options


4. Proceed to the "Print" option and preview the pages as needed.

5. You're all set! You can now print your Excel sheet. Before doing so, it's advisable to perform a spell-check on the document.

My User Experience:

Exploring this method revealed a dynamic way to present documents with a mix of introductory and standard information. I found it particularly advantageous when creating reports that required an overview or title on the first page. However, I suggest ensuring that the customized first page content is aligned with the document's purpose and doesn't overshadow subsequent pages' continuity.

go

Part 2: How to Insert a Footer in Excel Online

Excel Online, the cloud-based version of Excel, offers users the convenience of adding footers to their spreadsheets from any device with an internet connection. Discover how to seamlessly insert footers using Excel Online's user-friendly interface.

1. Access Your Excel Online Document: Open your web browser and navigate to the Microsoft Excel Online platform. Sign in to your account and access the spreadsheet to which you want to add a footer.

2. Navigate to the Insert Tab: Within Excel Online, locate and click on the "Insert" tab at the top of the screen.

Insert a Footer in Excel Online

source: excel options


3. Choose Footer: From the dropdown menu under the "Insert" tab, select "Header & Footer."

Insert a Footer in Excel Online

source: excel options


4. Customize Your Footer: A footer will appear at the bottom of your spreadsheet. Click inside the footer area to customize the content. You can include page numbers, dates, and other relevant information.

Insert a Footer in Excel Online

source: excel options


5. Apply the Footer: Once you've customized the footer, your changes will be saved automatically.

Part 3: How to Add a Footer in Excel on Mac

Excel for Mac offers a platform for creating and customizing footers to enhance the visual appeal and professionalism of your spreadsheets. Learn how to effortlessly add footers to your Excel documents on a Mac system.

1. Open Your Excel Document: Launch Excel on your Mac and open the spreadsheet to which you want to add a footer.

2. Navigate to the Insert Tab: At the top of the Excel window, locate and click on the "Header & Footer" tab.

Insert a Footer in Excel Online Mac

source: excel options


3. Choose Footer: From the dropdown menu under the"Header & Footer" tab, select "Footer."

4. Customize Your Footer: A footer area will appear at the bottom of your spreadsheet. Click inside the footer section to input and customize your desired content, such as page numbers, dates, or additional notes, images.

Insert a Footer in Excel Online Mac

source: excel options


5. Apply the Footer: After customizing the footer, your changes will be automatically saved. The footer you've created will appear on every page of your Excel document.

Part 4: Comparing Footer Methods in Excel

When it comes to adding footers in Excel, three methods stand out: Excel Online, Excel for Mac, and the standard Excel application. Excel Online offers easy access and collaboration, but requires an internet connection. Excel for Mac provides a native experience with both online and offline capabilities. The standard Excel app offers comprehensive features and customization, but might need occasional updates. Choose based on your device, customization needs, and accessibility preferences. Each method has its strengths, catering to different user preferences and requirements.

Part 5: Advantages of Using WPS Office

WPS options landing page

source: WPS options


While the methods discussed apply to both Microsoft Excel and WPS Office Spreadsheet, opting for WPS Office brings distinct advantages. Here's why you should consider downloading and using WPS Office for your spreadsheet needs.

  • Price: WPS Office offers an attractive advantage in terms of cost. It provides essential spreadsheet functionalities without a hefty price tag, making it an excellent choice for budget-conscious users.

  • Compatibility: WPS Office ensures compatibility with various file formats, including Microsoft Excel formats. This seamless compatibility means you can work on and share files across different platforms without compatibility issues.

  • Features: WPS Office boasts a range of features akin to its Microsoft counterpart. From data analysis tools to customizable templates, it covers all essential spreadsheet needs, ensuring your work is both efficient and comprehensive.

  • User-friendly Interface: WPS Office's user-friendly interface makes it accessible to users of all levels. Its intuitive design streamlines tasks, making it a preferred choice for those looking for efficiency without sacrificing ease of use.

    Trustpilotstars4.8
    WPS Office- Free All-in-One Office Suite
    5,820,008 User
    avator
    Algirdas Jasaitis
    logo
    • Use Word, Excel, and PPT for FREE, No Ads.

    • Edit PDF files with the powerful PDF toolkit.

    • Microsoft-like interface. Easy to learn. 100% Compatibility.

    • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

    FAQs about Excel Footer Customization

    Q1: How can I include the current date in the footer?

    A1: Including Current Date: To include the current date in the footer, click "Add Footer" or "Add Header," then choose "Insert" and select "Date," "Time," or other relevant options.

    Q2: What if I don't want a footer on the first page?

    A2: Excluding Footer on First Page: Double-click the footer area on the first page, delete its content, and the footer will be removed. Refer to earlier steps for clarity.

    Q3: Is it possible to add images or logos in footers?

    A3: Adding Images or Logos: Yes, you can add images or logos to footers. Go to "Insert," add a footer, insert text, images, or logos, and save your work. Customize as needed.

    Final Thought on How to add a footer in excel

    To sum up, mastering footer customization in Excel enhances spreadsheet professionalism. This guide's step-by-step approach ensures tailored footers for page numbers, dates, and images. Whether using Excel Online, Excel for Mac, or the standard Excel app, these methods elevate document presentation.

    For an efficient and budget-friendly solution, consider WPS Office. Its compatibility, rich features, and user-friendly interface simplify footer addition. Leveraging WPS Templates further enhances document aesthetics. With WPS Office, efficient and impactful footer customization becomes a reality.


    15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.