Print a header only on the first page

If your worksheet is longer than one page, you can put information like page numbers in a header to help your readers navigate your worksheet. Typically headers print the same information on every page but you can set up your header so it prints only on the first page. For example, you might want to print the sheet name on the first page.

 Important    If your worksheet already has information in the header, clear all the headers before you add the information you want to print on the first page. After you’ve set up the header for the first page, you can add headers to the remaining pages.

  1. Click Insert > Header & Footer.
  2. On the Design tab, check Different First Page.

Different First Page

  1. Click the left, center, or right box at the top of the worksheet and add the information you want to print only on the first page.

Left, right, and center header boxes

  1. When you’re done, click View > Normal.

Add headers to the remaining pages

After you’ve set up the header for the first page, you can add headers to the remaining pages. Here’s how:

  1. Click Insert > Header & Footer.
  2. On the second page of the workbook, click the left, center, or right box at the top of the worksheet and add the information you want to print at the top of the remaining pages.
  3. When you’re done, click View > Normal.

Why can’t I see the header in my workbook?

Click View > Page Layout. Headers show up only in Page Layout view, Print Preview, and on printed pages.

 
 
Applies to:
Excel 2013