How to add footer and header in Excel

Share on facebook
Share on twitter
Share on pinterest

Headers and footers can define your Excel file while you print it. They can show page numbers, file names, dates, or any other information you like to have on your printed file. If you don’t know how to a add footer and header in Excel, follow this post. You will see how simple it is.

Please note that headers and footers are only visible in Print Preview and Page Layout View. You won’t see them in Normal View worksheets. But if you add a footer and header in Excel, they are in your file until you remove them. We will also let you know how to edit or remove the footer and header in Excel.

How to insert header in Excel

  1. Open your file and select the sheet you want to add a header to. 
  2. Go to the Insert tab and click on Header and Footer, which is in the Text group. 
Inserting header in Excel
Figure 1-Inserting header in Excel

After clicking on Header & Footer, your worksheet turns into Page Layout View. Here you see where you can put your header.

Excel sheet in Page Layout View, you can see where the header is located.
Figure 2-Excel sheet in Page Layout View, you can see where the header is located.

Usually, your Page Layout will be in portrait mode. If your file is landscape, go to the Page Layout tab and click on Orientation, simply change Portrait to Landscape.

*Please note that it’s important to have the right orientation before printing your page. 

  1. This step is so clear you just need to click on top of the page where you see “Click to add header” has been written. The header has three sections. Click on the division you want to add a header. You can fill all three sections or use one of them. That depends on your preferences. 
  2. Choose from the list which opens under the Header (top left of the page) in the Design tab. You can also simply type any information you want to show on the header. 
You can select one of the elements in Header & Footer Elements too.
Figure 3- You can select one of the elements in Header & Footer Elements too.

  1. Whatever you write on the Excel header will be shown on every page of the same sheet. But if you want to add a header to another sheet, you can either follow this instruction again, or press Ctrl and select the sheets you want to have the same header and footer. Then start inserting header and footer in Excel. 

How to change header on Excel 

You can change and edit the Excel header whenever you want. 

  1. Open your Excel file. 
  2. Go to the View tab and choose Page Layout in the Workbook Views group.
Inserting header in Excel
Figure 4- Steps for changing Excel header.

You will see your sheet in Layout view, in which the header is visible. 

  1. Click on the header, delete or change any information you like. 
  2. If you don’t want to have a header anymore, go to Design> Header and select none. It will clear all the sections of the header. 
Removing a header in Excel
Figure 5- Removing a header in Excel

How to add a footer in Excel 

Inserting a footer in Excel is as simple as inserting a header. You should follow the same instruction. 

  1. Go to the Insert tab, click on Header & Footer
  2. In the Design tab, click on Go to Footer
Adding footer in Excel
Figure 6- Adding a footer in Excel

The footer is precisely like the header. It has three sections, and you can add all the elements you could add for the header. 

How to change or remove footer in Excel 

Follow the instructions about editing or deleting a header in Excel. 

Options on Header & Footer Design Tab

There are different options on Design Tab while you are adding a header or footer for the Excel sheet. We are going to explain them briefly. 

  • Different First Page: if you want the first page of your Excel sheet to have a different header or footer, fill this checkbox. Now you can add another header just for the first page. 
  • Different Odd & Even Pages: fill this checkbox if you want your pages to have different header and footer on odd and even pages. Therefore, you will set a header and footer for odd pages and another for even pages. 
  • Scale with Document: if you fill this checkbox, the header and footer will change according to the page size. 
  • Align with Page Margins: this option will also fit the header and footer in the page margin. Therefore, while you print the page, everything will be in the right place. 

Add header and footer from Page Layout 

There is another method for adding header and footer in Excel. 

  1. Go to the Page Layout tab and click on the small arrow on the bottom right of the Page Setup group. A window will display. 
  2. Click on the Header/Footer tab. 
Adding header and footer via Page Layout
Figure 7- Adding header and footer via Page Layout

  1. If you want to add a header, click on the Custom Header button, and if you want to add a footer, choose Custom Footer
  2. By choosing either of them, another window will show up. You can pre-set headers and footers here. 
  3. There are more options here to customize your header and footer. You can change your font size, color, effects, and style. 
Select the font size, color, style and other related options
Figure 8- Select the font size, color, style and other related options.

To see the result of these changes, press the Print Preview button.  

Bottom Line

Inserting a header and a footer in Excel is so simple. If you learn how to add a footer and header in Excel, you can make better reports on Excel. Headers and footers can make your document more organized, and while printing the file, you can easily see the important information about it on the header or footer. 

If you are a beginner to Excel, we recommend you to read the Complete Guide To Excel Basics.

Subscribe to our Newsletter

Share this post with your friends

Share on facebook
Share on google
Share on twitter
Share on linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *