How to Create a Custom Footer in Excel – Header and Footer

  • Home
  • / How to Create a Custom Footer in Excel – Header and Footer

Users often tend to make changes in their spreadsheets according to their choice. Sometimes, your files need improvements in terms of style and professionalism and for this, you can apply different headers and footers on each page of the sheet.

Do you know how to create a custom footer in Excel?

Usually, headers and footers are clear-cut indications of general information about the document including page number, date, workbook name, file path, etc. With Excel, you can have a huge variety of predefined headers as well as footers so that you don’t need to create one. However, some users want to have customized headers and footers.

Excel 2019 gives the option to create a custom footer. Built-in footers are sometimes not enough to use because they lack the information you need to add to the sheet. Therefore, users tend to avoid these ready-made headers and footers and prefer making their own.

Why Do You Have to Add a Header and Footer in Excel?

Headers and footers are the most common feature in Excel, still, some users are not aware of their use. Below are some of the useful benefits of adding header and footer that you can enjoy:

Quick Information

You get clear information about the file and it lets you edit that information according to your liking such as current date, page numbers, filename, or path, etc.

Obvious Formation

When a spreadsheet includes graphs, calculations, and pivot tables, Excel lets you use headers and footers to break down that information easily to make it comprehensible.

Professional Structure

To generate reports, it is a great option to present data in a highly organized and appealing manner.

How to Create a Footer in Excel?

Before getting into how to create a custom footer in Excel, let’s understand the simple method of how you can insert built-in footers in Excel. Below are some easy steps:

Open the Insert tab and click on the Header & Footer option given in the Text group menu.

Select the Go to Footer option in the Design tab. Or else you can scroll down to the footer boxes given at the end of the page.

Now, choose a location, left, center, or right footer box, and enter text or whatever you need to insert as the footer.

Once you are done with it, click anywhere on the sheet and the footer window will be closed.

If you need to add the page numbers at the lower end of the sheet, you can choose one of the footer boxes and click on the Page Number given in the Design tab.

That’s it!

Price banner Earn and Excel

How to Create a Custom Footer in Excel?

Now, you are aware of the steps you need to follow to insert a ready-made footer in Excel. Let’s have a look at some identical but different steps to add a custom footer.

All the steps are similar except the one in which you enter data in the left, right, or center boxes at the bottom of the page. It ensures the data sets off the information present in the header. You can add whatever you want in the footer section such as company logo, page number, date, sheet name, etc.

How to Add Headers and Footers with Page Setup Dialog Box?

The Page Setup option is an awesome thing when you need to add a header or footer for chart sheets. It is also helpful when you need to add a footer for different sheets simultaneously.

Here are the steps:

  • Select one or more sheets for which you need to create a header or footer. For this selection, press and hold the CTRL key while clicking on the sheet tabs.
  • Open the Page Layout tab and choose the Page Setup option.
  • Click on the Dialog Box Launcher menu.

  • Now, select one of the built-in headers and footers from the Page Setup dialog box or you can even make your own.
  • In case, you don’t need to create a new one, click on the drop-down arrow present in the Header or Footer box and select an option. For instance:

  • On the other hand, if you want to create a custom header or footer, do the following:
  • Click on the Custom Header or Custom Footer button.
  • Choose the location left, center, or right box and click on the buttons given above the sections. You can check each option one by one to see what function they are producing.
  • The below example explains how you can add a page number to the right side of the Excel header:

  • You can add whatever text you want in any section or edit and remove the existing text.
  • Once you are done, click OK.
  • You can have an idea of how your added headers and footers look like, you can simply go to the Print Preview option.

That’s it!

This is how to create a custom footer in Excel and you can see the process is not lengthy. Therefore, you can apply different formats of headers and footers to check which one suits best to your sheet.

Price banner Earn and Excel

Write your comment Here