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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Hide Header and Footer in Excel: 2 Simple Methods

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


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


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.

Download Practice Workbook

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


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

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram, BSc, Industrial and Production Engineering, Ahsanullah University of Science & Technology, has been working with the ExcelDemy project for 10 months. Currently working as as Excel and VBA content developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He published almost 150 articles and has many more coming. He is very passionate about learning new things about Microsoft office Suite and Data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo