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

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 in all other newer versions.


Download Practice Workbook


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.

And you will see the Footer at the bottom of each page.

 footer


6 Ways to Remove Header and Footer in Excel

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

If you feel curious how this image has been added to the Header, you can go to this link.

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 Edit Header in Excel (6 Easy Methods)


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

Read More: How to Edit Footer in Excel (3 Quick Methods)


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.

Read More: How to Insert a Footer in Excel (2 Suitable Ways)


Similar Readings


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

Read More: How to Remove Hyperlink from Excel (7 Methods)


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 Remove Print Lines in Excel (4 Easy Ways)


6. Using VBA

You can also use Microsoft Visual Basic Application (VBA) to remove 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

Read More: How to Add Header in Excel (5 Quick Methods)


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

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo