How to Remove a Header in Excel (4 Methods)

A header is a significant tool for presenting a dataset by adding a title, date, page no., or anything else at the top of the sheets in Excel. But occasionally, we might need to remove the header from documents. In this article, I’ll present to you 4 practical methods on how to remove a header in Excel including the VBA code.


Download Practice Workbook


4 Methods of Removing a Header in Excel

Well, you are observing a header i.e. Product Order Records in bold-colored in the following screenshot. Now we are going to remove the header utilizing the 4 methods.

Dataset


1. Using the Page Setup to Remove a Header in Excel

Firstly, we’ll see the most popular method for removing the header in a step-by-step process.

⏩ Go to Page Layout tab > click on the drop-down arrow located at the right bottom of the Page Setup ribbon.

How to Remove a Header in Excel_Using the Setup to Remove a Header in Excel

⏩ Then you’ll find a dialog box namely the Page Setup as shown in the following figure.

⏩ Next, move the cursor on the Header/Footer option.

⏩ Choose the (none) option from the drop-down list, and lastly press OK.

How to Remove a Header in Excel_Using the Setup to Remove a Header in Excel

⏩ You’ll get the following output if you do the above steps.

How to Remove a Header in Excel_Using the Setup to Remove a Header in Excel

⏩ Furthermore, if you wish to remove the space invaded by the header, pick the Normal view from the View tab as depicted in the following picture.

How to Remove a Header in Excel_Using the Setup to Remove a Header in Excel

So, your sheet will look as if you didn’t have any header.

How to Remove a Header in Excel_Using the Setup to Remove a Header in Excel

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


2. Deleting a Header While Printing from Excel

When you want to delete the header before printing the document, the following method will be highly beneficial for you.

In the beginning, you need to see the print preview by clicking File > Print > Print Preview (the keyboard shortcut is CTRL + P).

Deleting a Header While Printing from Excel

So, it is clear that we have a header in our document. Thereafter, choose the Page Setup option as indicated in the following screenshot.

Deleting a Header While Printing from Excel

Meanwhile, a dialog box i.e. Page Setup will be opened as earlier in the first method.

So, fix the Header as (none) from the Header/Footer option (red-colored in the picture).

Deleting a Header While Printing from Excel

Subsequently, you are going to get the following output where no header is available on the page while previewing the page for printing.

Deleting a Header While Printing from Excel

Read More: How to Edit Header in Excel (6 Easy Methods)


Similar Readings


3. Method of Removing a Header from the Second Page

Again, we’ll implement an interesting but simple method for removing the header from the second page on the single working sheet.

Before doing that we need to understand how we can add different named headers within a worksheet.

⏩ Move the cursor over the selected cell for the current header and check the box before the Different First Page option from the Header & Footer tab. Now the header on the first page will be separate from the other headers.

Method of Removing a Header from the Second Page

⏩ Shift the cursor at the column of the right side (outside the current dataset) and select the Insert Page Break option from the Page Setup ribbon.

Method of Removing a Header from the Second Page

⏩ Then type a new header (Product Order Records-2)  in the dedicated space of page-2.

Method of Removing a Header from the Second Page

⏩ Now, remove the header from the second page by choosing the Header as (none) from the Header & Footer tab.

Method of Removing a Header from the Second Page

⏩ Finally, you’ll get the following output where no header exists on the second page but exist on the first page.

How to Remove a Header in Excel Method of Removing a Header from the Second Page

In the same manner, you can delete the header from the first page without removing the header of the second page.

Related Content: How to Insert a Footer in Excel (2 Suitable Ways)


4. Using VBA Code to Remove a Header in Excel

Lastly, you may remove a single header or the number of headers within a sheet by using a simple VBA code.

The steps will be as follows-

Step 1:

As we want to use VBA, we must know how to insert a VBA code.

Firstly, open a module by clicking Developer > Visual Basic.

How to Insert VBA Code

Secondly, go to Insert > Module.

How to Insert VBA Code

Step 2:

Then copy the following code into the newly created module.

Sub Removing_Header()
With Sheets("Sheet4").PageSetup
    .LeftHeader = ""
    .CenterHeader = ""
    .RightHeader = ""
End With
End Sub

How to Remove a Header in Excel_Using VBA Code to Remove a Header in Excel

In the above code, I used Sheets collection to get the sheet (Sheet4) where I want to remove the header. Besides, I assigned PageSetup which holds all page setup properties (e.g. margins, header & footer, and so on). After assigning those, I fixed all types of the header (left, right & right header) as blank to remove the header existing in my worksheet.

Step 3:

Next, run the code (the keyboard shortcut is either F5 or Fn + F5) and the output will be as follows.

How to Remove a Header in Excel_Using VBA Code to Remove a Header in Excel

Related Content: How to Remove Formulas in Excel: 7 Easy Ways


Things to Remember

  • If you want to just close the header immediately (instead of removing), just press Esc.
  • Moreover, if you want to remove the header quickly, simply select the header and press the Delete or Backspace key.

Conclusion

On the whole, we explored 4 methods including the VBA code and some shortcuts to remove a header in Excel. I personally think that the above guideline surely will be useful for you.

Enjoy Excel and visit our website exceldemy, an outstanding platform for learning Excel!


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo