How to Hide Header and Footer in Excel (2 Easy Methods)

The header and footer are materials that you want to visualize on top or bottom of every page. The header is the top portion and respectively footer is the bottom portion of a document. Mostly these areas are used for inserting information, heading, page numbers, date, etc. While working in Microsoft Excel we might find the header and footer tab displayed at the top and bottom of the page. You can hide them if you want. In this article, I am sharing with you how to hide header and footer in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Simple Methods to Hide Header and Footer in Excel

In the following article, I have shared 2 simple and easy methods to hide the header and footer in excel.

Suppose we have a dataset of some Student’s Name and their perspective Department. Now we will add the header and footer to this workbook.

Hide Header and Footer in Excel

  • While in the workbook choose “Page Layout” from the “Workbook Views” option.

Hide Header and Footer in Excel

  • At the top of the workbook, the header section will be visible.

  • Similarly, at the bottom of the sheet, the footer section is visible too.


1. Use View Option to Hide Header and Footer

By changing the workbook view you can quickly hide the header and footer. Follow the steps below-

Steps:

  • Above all, select “Normal” from the “Workbook Views” option.

Use View Option to Hide Header and Footer in Excel

  • In conclusion, by changing the view to the normal mode we have successfully hidden the header and footer in excel.

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


2. Utilize Status Bar to Hide Header and Footer

You can also change the view from the status bar to hide the header and footer in excel. To do so-

Steps:

  • First, click the “Normal View” icon from the status bar.

  • Therefore, you will get the output hidden header and footer in excel.

Utilize Status Bar to Hide Header and Footer

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


Things to Remember

  • If you write down anything on the header or footer section and hide the section by changing the view you won’t be able to view the header and footer section. But it will be visible when you print the document.

Conclusion

In this article, I have tried to cover all the methods to hide header and footer in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo