Add a Custom Header in Excel

In Excel, 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

In Excel, a custom header is added in Page layout 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 layout 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 leaves you in Page Layout view. While it is possible to work in this 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

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.
  
  
• Change to Print Preview:

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

  1. In Excel 2007, click on the Office Button.
     
  2. Choose Print > Print Preview from the drop down menu.
  1. In Excel 2010, click on the File tab of the ribbon.
     
  2. Click on Print in the menu.
  3. Your worksheet should appear in the preview panel on the right of the screen

• excel formatting
• excel headers and footers