Excel Tutorials: How to use Excel 2007 Custom Header

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.


In Excel 2007, a header is a line of text that prints at the top of each page in the spreadsheet.

A header is used to add information to a spreadsheet before it is printed. Custom headers can be used to add specific information, such as a title, or description of the worksheet.

A header can appear in three locations on the spreadsheet - the top left corner of each page, the top center, and the top right corner of each page.

Adding a Custom Header in Excel 2007

In Excel 2007, a custom header is added in page view. To add a header:

1. Click on the Insert tab.
   
   
2. Click on the Header & Footer option in the ribbon.
   
   
3. The spreadsheet switches to page view.
   
   
4. Three boxes can be seen above the worksheet page.
   
   
5. By default, the center box is highlighted.
   
   
6. Click with the mouse on either of the side boxes to change the location of the header if desired.
   
   
7. Type in the header information.

Returning to Normal View

Once you have added the custom header information, Excel 2007 leaves you in Page view. While it is possible to work in page view, you may want to return to Normal view. To do so:

1. Click on any cell in the worksheet to leave the header area.
   
   
2. Click on the View tab.
   
   
3. Click on the Normal option in the ribbon.

Viewing the header

Note:Headers are not visible in Normal view. To view a header choose one of these options:

• Change to Page view:
  1. Click on the View tab.
  2. Click on the Page View option in the ribbon.
  3. The header should now be visible.
• Change to Print Preview:
  1. Click on the Office Button.
  2. Choose Print > Print Preview from the drop down menu.
  3. The header should now be visible.

Note: You must have a printer installed on your computer to use Print preview.