How to Remove Header and Footer in Excel (6 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

header

Your dataset also has a Footer.

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.


Find Header and Footer in Excel

If you look at your Excel sheet you won’t see any Header in normal view.

dataset

If you scroll down, you won’t see the Footer either.

no footer

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.

Insert tab

You can also click on the Page Layout icon from the Status Bar.

View

As a result, your worksheet layout will be changed. Now, you will see the Header at the top of your workbook.

Header

➤ Scroll down.

You will see the Footer at the bottom of each page.

 footer


How to Remove Header and Footer in Excel: 6 Ways

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.


1. Remove Header and Footer Using the Insert Tab

To remove Header and Footer using the insert tab first,

➤ Go to Insert > Text > Header & Footer.

Insert

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.

remove header

After that,

➤ Click somewhere else in your worksheet.

You will see that the Header has been removed.

remove header

To remove the image Header,

➤ Click on the image.

Now, the image will turned into a text in this format &[Picture]

➤ Delete this text.

custom header

Now,

➤ Click somewhere else in your worksheet.

You will see the Header has been removed from your worksheet

header removed

In a similar manner, you can also remove the Footer.

remove header and footer in ExcelRead More: How to Hide Header and Footer in Excel


2. Page Layout Tab to Remove Header and Footer

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.

remove header and footer in Excel

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.

Page setup

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.

remove header and footer in Excel

As a result, all the Headers and Footers will be removed from your worksheet.

remove header and footer in Excel


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.

view tab

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.

remove header

In a similar way,

➤ Delete all the Headers.

remove header and footer in Excel

Now,

➤ Scroll down till you see the Footer.

➤  Click at the end of any Footer and press BACKSPACE to delete the Footer.

remove footer

In a similar way,

➤ Delete all the Footers.

remove header and footer in Excel

As a result, all the Headers and Footers of your worksheet will be removed.


4. Remove Header and Footer Using Status Bar

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.

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.

header


5. Remove Header and Footer When Printing

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.

Print

Here you will see the current page of your worksheet in Print Layout.

print layout

Now,

➤ Click on Page Setup in the Print menu.

page setup

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.

remove header and footer in Excel

As a result, the Header and the Footer of your worksheet will be removed.

remove header and footer in Excel

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.

VBA WINDOW

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.

code

➤ Press F5 and close the VBA window.

You will see, all the Headers have been removed from your Excel worksheet.

remove header

➤ Scroll down.

You will realize the Footers are also gone.

remove footer


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.


Related Articles


<< Go Back to Header and Footer  | Page Setup in Excel | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo