How to Close the Header Footer Screens in Excel 2007

Reset Normal View
1. Press the 'Esc' key if you are in 'Full Screen' mode and cannot see the Office Ribbon.
2. Click the 'Views' tab on the Office Ribbon.
3. Select 'Normal' in the 'Workbook Views' section. This will work from any view unless you have an open dialog box that you must address first. In that case, click 'Cancel' or 'OK' in the dialog box, depending on what the screen prompts say, then select the normal view.
Within Page Layout View
4. 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.
5. 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.
6. Scroll to the bottom of the page and place your cursor along the bottom edge until the double arrow icon appears again.
7. Click to close the footer.