Header and Footer contains different information of a document such as chapter name, author name, page number, publisher logo etc. in the top and bottom of each page of that document. The top part of a page including this information is called Header and the bottom part is called Footer. Though Header and Footer prepare your Word document or Excel file for printing, Sometimes you need to remove those, especially if they contain wrong information. In this article, I’ll show you 6 effective ways to remove Header and Footer in Excel.
Consider you have the following dataset with a Header.
Your dataset also has a Footer.
Now, I’ll show you how you can remove the Header and Footer from this dataset. I’ve prepared this article using Excel 365. You can apply the same methods in Excel 2007, Excel 2010, Excel 2013, Excel 2016, and all other newer versions.
If you look at your Excel sheet you won’t see any Header in normal view.
If you scroll down, you won’t see the Footer either.
This is because the Header and the Footer aren’t shown in the normal view of Excel. To find out the Header and the Footer you have to change the view from normal to page layout.
➤ Go to the View tab and select Page Layout from the Workbook Views ribbon.
You can also click on the Page Layout icon from the Status Bar.
As a result, your worksheet layout will be changed. Now, you will see the Header at the top of your workbook.
➤ Scroll down.
You will see the Footer at the bottom of each page.
Now, I will show you 6 ways to delete Header and Footer from your worksheet. You can use any of these to remove both the Header and the Footer.
To remove Header and Footer using the insert tab first,
➤ Go to Insert > Text > Header & Footer.
As a result, it will change the worksheet view as Page Layout view. Here you will see the existing Headers at the top.
➤ Click on any Header and press BACKSPACE to delete the Header.
After that,
➤ Click somewhere else in your worksheet.
You will see that the Header has been removed.
To remove the image Header,
➤ Click on the image.
Now, the image will turned into a text in this format &[Picture]
➤ Delete this text.
Now,
➤ Click somewhere else in your worksheet.
You will see the Header has been removed from your worksheet
In a similar manner, you can also remove the Footer.
Read More: How to Hide Header and Footer in Excel
You can find another way to remove Header and Footer from the Page Layout tab.
➤ Go to the Page Layout tab and click on the little arrow from the bottom right corner of the Page Setup ribbon.
It will open the Page Setup window.
From this window, you will be able to change different properties of a page such as page size, orientation, margin, Header and Footer, etc.
Now,
➤ Go to the Header/Footer tab in the Page Setup window.
After that,
➤ Select none in the Header box and again select none in the Footer box.
At last,
➤ Click on OK.
As a result, all the Headers and Footers will be removed from your worksheet.
3. From the View Tab
You can also remove Header and Footer from the View tab.
➤ Go to the View tab and select Page Layout from the Workbook Views ribbon.
As a result, it will change the worksheet view to Page Layout view. Here you will see the existing Headers at the top.
➤ Click at the end of any Header and press BACKSPACE to delete the Header.
In a similar way,
➤ Delete all the Headers.
Now,
➤ Scroll down till you see the Footer.
➤ Click at the end of any Footer and press BACKSPACE to delete the Footer.
In a similar way,
➤ Delete all the Footers.
As a result, all the Headers and Footers of your worksheet will be removed.
You can also remove Header and Footer from the Status Bar.
➤ Click on the Page Layout view icon from the bottom right corner of your Status Bar.
As a result, it will change the worksheet view as Page Layout view. Here you will see the existing Headers at the top. Now, you can follow these steps from the previous method to remove the Header and Footer from your Excel worksheet.
You can also apply another method to remove Header and Footer when you are printing the Excel worksheet.
➤ Go to the File tab and select Print.
Here you will see the current page of your worksheet in Print Layout.
Now,
➤ Click on Page Setup in the Print menu.
It will open the Page Setup window.
From this window, you will be able to change different properties of a page such as page size, orientation, margin, Header and Footer, etc.
Now,
➤ Go to the Header/Footer tab in the Page Setup window.
After that,
➤ Select none in the Header box and again select none in the Footer box.
At last,
➤ Click on OK.
As a result, the Header and the Footer of your worksheet will be removed.
Read More: How to Insert a Footer in Excel
6. Using VBA
You can also use Microsoft Visual Basic Application (VBA) to remove the Header and Footer from your Excel Worksheet.
➤ Press ALT+F11 to open the VBA window.
➤ Select the Insert tab and click on Module.
It will open the Module(Code) window.
➤ Type the following code in the Module(Code) window,
Sub Remove_Header_Footer()
With Sheets("VBA").PageSetup
   .LeftHeader = ""
   .CenterHeader = ""
   .RightHeader = ""
   .LeftFooter = ""
   .CenterFooter = ""
   .RightFooter = ""
End With
End Sub
In the above code, Sheets collection has been used to get the sheet (VBA) from where the Header and the Footer will be removed. After that, PageSetup has been assigned to hold all page setup properties (e.g. margins, Header & Footer, and so on).
At last, all types of Headers and Footers (left, right & right Header) have been set to blank for removing the Headers and Footers from the VBA worksheet.
➤ Press F5 and close the VBA window.
You will see, all the Headers have been removed from your Excel worksheet.
➤ Scroll down.
You will realize the Footers are also gone.
Download Practice Workbook
Conclusion
I hope now you know how to remove Headers and Footers in Excel. If you have any confusion, please feel free to leave a comment.