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.
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.
Tips and warnings
- 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.