How to insert a footer in Excel on Mac

In Excel, you can place a header and footer upon your worksheet to add extra information and assist with sorting. Often page numbers, dates, categories are included. Headers and footers can be located on the left, middle or center of the page.

Excel 2007 and 2010

1. Click the View tab.

2. Select Page Layout.

3. Click in the area marked Click to add header or Click to add footer.

4. Choose where you want the text to be, left, center or right aligned.

5. Type the desired text in the appropriate box.

6. Click the Home tab to apply formatting to the text (font, bold, underline, or color).

Excel 2011

1. Select the Layout tab

2. Click Header & Footer

3. Customize the header information in the dialog box that appears.

Alternatively, you can also manually insert a header or footer by clicking at the blank area at the top or bottom of the page while your are viewing from Layout -> Page Layout mode.

Headers and footers are widely used in the Microsoft Word document, but you should know that Excel has headers and footers too.

To add a header and footer in your worksheet, follow the next steps:

   1.   On the Insert tab, in the Text group, click Header & Footer:

Excel displays the worksheet in Page Layout View. You can also click Page Layout view

   2.   Click the left, center, or right header or footer text box at the top or at the bottom of the worksheet page.

Clicking any text box selects the header or footer and displays the Header & Footer Tools, adding the Design tab:

   3.   Under Header & Footer Tools, on the Design tab, in the Header & Footer Elements group, click the element that you want.

Note: To return to Normal view, on the View tab, in the Workbook Views group, click Normal. You can also click Normal on the status bar:

Excel is not only a powerful tool for data storage and transformation, it is also widely used for data analysis, so it offers a great range of features to make data more visually accessible. All Excel versions allow you to insert a header and footer to your spreadsheet, which can be pre-defined or custom.

Adding headers and footers to your spreadsheets is a great way to visually improve your files, and make them ready in a professional setting, such as reports. Since headers and footers are mainly designed for printed pages, they won’t interfere with your worksheet view; they are only visible in Print Preview and Page Layout view.

In this article, we’ll show you how to add a header in Excel for all pages, how to add a footer in your Excel spreadsheet, as well as how to edit a header and footer to showcase the information you need.

Since most users are unaware that this feature exists, here are the main benefits of adding a header and footer in your Excel spreadsheet.

• Quick information: You can select and edit the type of information to include regarding your spreadsheet, such as page number, current date, filename, path, etc.
• Clear structure: If your spreadsheet includes calculations, graphs, and pivot tables, headers and footers allow you to break down the information in a much easier way to understand.
• Professional layout: If you need to generate reports, this is a great way to present your data in an organized and appealing way.

Now that you have seen what headers and footers are used for, we’ll explain how to add a preset header in Excel.

1. 1. Go to Insert > Header & Footer. The worksheet should change to “Page Layout” view.

1. 2. To add a preset header, click on “Add header”, then click on the drop-down arrow in the “Header” button to browse through the list of preset headers. These combine information relating to page number, file name, file path, date, etc.

1. 3. Once you click on a preset header, Excel automatically inserts the data following the preset order. Here, I selected the last preset, which includes information on the author and date in the center section, and the page number to the right.

1. 4. To edit the order or contents of the preset header, simply click on the header section and change accordingly. Here, I will change the author's name to “J. Smith”.

Click anywhere in your spreadsheet to leave the header area. If you want to leave without saving changes, press Esc. This header will now appear on all pages of your Excel spreadsheet, so make sure that you want this information on all printed pages.

Now that you’ve seen how easy it was to insert a preset header in Excel, let’s create your own custom header.

1. 1. Go to Insert > Header & Footer.
2. 2. Click on any of the header sections and type in the information you would like to include. You can also select one of the preset elements in the toolbar and arrange it according to your needs. Here, I will start by adding a “Picture” element to insert my company logo.

1. 3. Browse for the image you want and select it. You can then click on “Insert” or double-click on the image file.

1. 4. Excel shows the “&[Picture]” command to include the image you select. However, if you want to view the image in your spreadsheet, click anywhere outside the header box.

1. 5. Follow the same process for the other two sections of the header. Here, I will include the date in the center header section and the page number to the right.

Make sure that the image quality is good enough for printing and that it won’t interfere with the rest of the data ‌in the worksheet.

Like the header, you’ll see how easily you can add a footer in Excel.

1. 1. Go to Insert > Header & Footer or simply double-click on the footer box.

1. 2. Click on the drop-down arrow in the “Footer” button to browse through the list of preset footers, which combine the same information as for the header.

1. 3. Make sure that the footer complements, not repeats, your header information. Since I included the company logo, date, and page number before, I will simply include the filename below, “2021 REPORT.xlsx”.

1. 4. Remember that you can always edit by simply clicking on the box and applying the desired change.

Once you finish editing your footer in Excel, click outside the box or press “Esc” to leave without saving.

The steps to add a customer footer are almost identical to adding a custom header. The only difference is that you will enter data in the left, center, and right boxes at the bottom of the page, making sure that the data complement the one in the header.

Here, I have only included the file and sheet name, as the header already contains the company logo, date, and page number.

How to automate your data on top of Google Sheets?

Layer is an add-on that equips you with the tools to increase efficiency and data quality in your processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.

Using Layer, you can:

• Share & Collaborate: Automate your data collection and validation through user controls.
• Automate & Schedule: Schedule recurring data collection and distribution tasks.
• Integrate & Sync: Connect to your tech stack and sync all your data in one place.
• Visualize & Report: Generate and share reports with real-time data and actionable decisions.

Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your processes on top of Google Sheets!

Conclusion

Adding a header or footer into your spreadsheet is a great way to turn your spreadsheets into a more professional, visual document. They are a great option to consider if you need to present your data to other team members or even your stakeholders.

By the end of this article, you have learned how to add a preset and custom header and footer to provide additional information on the spreadsheet. Although the examples in this article show how to add a header and footer in Excel for Mac, the steps shown here are very similar to Excel for Windows.

If you want to know more about how to organize and structure your data to make it more accessible, you will be interested in our article on Conditional Formatting in Excel: the Complete Guide.

How do you insert a Footer in Excel?

Why wont Excel let me insert a Footer?

Are there footers in Excel?

How do I close Header and Footer in Excel for Mac?