How To Add Footer And Header In Excel

5.5 min read|Last Updated: October 19th, 2020|Categories: excel|
table of content

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.