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

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.

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

Your dataset also has a Footer.

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

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.

Table of Contents hide

Download Practice Workbook

Find Header and Footer in Excel

6 Ways to Remove Header and Footer in Excel

1. Remove Header and Footer Using the Insert Tab

2. Page Layout Tab to Remove Header and Footer

3. From the View Tab

4. Remove Header and Footer Using Status Bar

5. Remove Header and Footer When Printing

6. Using VBA

Conclusion

Related Articles

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.

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

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

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

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.

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

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

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

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

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

➤ Scroll down.

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

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

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.

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

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.

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

After that,

➤ Click somewhere else in your worksheet.

You will see that the Header has been removed.

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

To remove the image Header,

➤ Click on the image.

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

➤ Delete this text.

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

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

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

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

How to Remove Header and Footer in Excel (6 Methods) - ExcelDemy (14)Read 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.

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

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.

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

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.

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

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

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

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.

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

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.

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

In a similar way,

➤ Delete all the Headers.

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

Now,

➤ Scroll down till you see the Footer.

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

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

In a similar way,

➤ Delete all the Footers.

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

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

  • How to Add Same Header to All Sheets in Excel (5 Easy Methods)
  • Remove Percentage Symbol in Excel (4 Ways)
  • How to Insert Symbol in Excel Header (4 Ideal Methods)
  • Remove Metadata from Excel File (3 Methods)
  • How to Insert Symbol in Excel Footer (3 Effective Ways)

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.

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

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.

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

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.

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

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

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

Now,

➤ Click on Page Setup in the Print menu.

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

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.

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

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

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

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.

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

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 WithEnd 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.

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

➤ Press F5 and close the VBA window.

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

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

➤ Scroll down.

You will realize the Footers are also gone.

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

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

  • How to Move Header in Excel (with Easy Steps)
  • Remove Decimals in Excel (13 Easy Ways)
  • How to Repeat Rows in Excel at Bottom (5 Easy Ways)
  • Remove Subtotals in Excel (2 Easy Tricks)
  • How to Insert Logo in Excel Header (4 Easy Ways)
  • Remove Macros from Excel (5 Suitable Ways)
  • How to Hide Header and Footer in Excel (2 Easy Methods)
How to Remove Header and Footer in Excel (6 Methods) - ExcelDemy (2024)
Top Articles
Latest Posts
Article information

Author: Edmund Hettinger DC

Last Updated:

Views: 5571

Rating: 4.8 / 5 (58 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Edmund Hettinger DC

Birthday: 1994-08-17

Address: 2033 Gerhold Pine, Port Jocelyn, VA 12101-5654

Phone: +8524399971620

Job: Central Manufacturing Supervisor

Hobby: Jogging, Metalworking, Tai chi, Shopping, Puzzles, Rock climbing, Crocheting

Introduction: My name is Edmund Hettinger DC, I am a adventurous, colorful, gifted, determined, precious, open, colorful person who loves writing and wants to share my knowledge and understanding with you.