00_lead_image_different_first_page

You can add text, such as page numbers, filename, worksheet name, and date, to the header and footer on your spreadsheet. But, what if you want the first page of your worksheet to have a different header than the rest? That’s an easy task to accomplish.

NOTE: We used Excel 2016 to illustrate this feature.

To make header and footer on the first page of the current worksheet different from the rest of the pages, click the “Page Layout” tab.

01_clicking_page_layout

In the “Page Setup” section, click the “Page Setup” button in the lower-right corner.

02_clicking_page_setup_button

The “Page Setup” dialog box displays. Click the “Header/Footer” tab.

03_clicking_header_footer_tab

Click the “Different first page” check box so there is a check mark in the box.

04_clicking_different_first_page

Once you’ve turned on the “Different first page” option, you can customize the header for the first page of the spreadsheet and the header for the rest of the pages. Click “Custom Header”.

05_clicking_custom_header

The “Header” tab is where you specify the header for all the pages after the first page, which, in our example, is the page number and the total number of pages. For the first page of your spreadsheet, you may want to leave the header blank, which is the default. However, for our example, we’ll add different text. To do so, click the “First Page Header” tab.

06_clicking_first_page_header_tab

Click in the “Left section” box, “Center section” box, or “Right section”, depending on where you want to put the content of your header. You can have content in all three boxes. We’re going to add the filename to the center of the header, so click in the “Center section” box and then click the “Insert File Name” button.

07_clicking_insert_file_name

To accept your changes and close the “Header” dialog box, click “OK”.

08_file_name_inserted

You’re returned to the “Page Setup” dialog box. Click “OK” to close it.

09_closing_page_setup_dialog

We created a custom header in this example, but you can also create a custom footer in the same way using the “Custom Footer” button on the “Page Setup” dialog box.

You can also use this dialog box to make the header and footer different for odd and even pages, by selecting the “Different odd and even pages” check box on the “Header/Footer” tab on the “Page Setup” dialog box. Then, you can customize the different headers and footers for the odd and even pages using the “Custom Header” and “Custom Footer” buttons.