How to Close the Header & Footer Screens in Excel 2007

Anne HirshUpdated February 21, 2017

Microsoft Excel offers multiple viewing options, so the method to hide the headers and footers depends on which view you're in. Your Excel workbooks may be set to default to a specific view, but if you have large amounts of data, seeing the headers and footers on your screen can take up valuable space that could allow you to read and manipulate more data. If you are new to the Excel 2007 environment, you may also find yourself stuck in the header and footer editing screens. Fortunately, there are many ways to close your header and footer views.

Press the "Esc" key if you are in "Full Screen" mode and cannot see the Office Ribbon.

Click the "Views" tab on the Office Ribbon.

Select "Normal" in the "Workbook Views" section. This will work from any view unless you have an open dialogue box that you must address first. In that case, click "Cancel" or "OK" in the dialogue box, depending on what the screen prompts say, then select the normal view.

Place your cursor at the top edge of the page, where the white that represents the page ends before the top ruler or formula bar. The cursor will turn to an icon with two arrows pointing toward each other.

Click your mouse button while the cursor is in this mode. This hides your header and top margin while keeping you in "Page Layout" view.

Scroll to the bottom of the page and place your cursor along the bottom edge until the double arrow icon appears again.

Click to close the footer.

Tip

If you want to simply close the header and footer editing screen, click "Cancel" to close without saving or click "OK" to save your header and footer changes and close. These buttons are in the lower right area of the dialogue box.

Choose Citation Style

Hirsh, Anne. (2017, May 13). How to Close the Header & Footer Screens in Excel 2007. . Retrieved from http://www.ehow.co.uk/how_7208295_close-footer-screens-excel-2007.html

Hirsh, Anne. "How to Close the Header & Footer Screens in Excel 2007" last modified May 13, 2017. http://www.ehow.co.uk/how_7208295_close-footer-screens-excel-2007.html

Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.

About the Author

Anne Hirsh has been writing and editing for over 10 years. She has hands-on experience in cooking, visual arts and theater as well as writing experience covering wellness and animal-related topics. She also has extensive research experience in marketing, small business, Web development and SEO. Hirsh has a bachelor's degree in technical theater and English and post-baccalaureate training in writing and computer software.