How to create different headers and footers on odd and even pages

Excel 365
Odd and even pages may have different headers and footers on printing Excel spreadsheets like different pages in Word documents.
Different headers and footers on odd and even pages in Excel 365

To add a header or footer to the spreadsheet, do one of the following:

  • On the Insert tab, in the Text group, click Header & Footer:
    Header and Footer in Excel 365   or   Header and Footer in Excel 365

    Note: After clicking the Header & Footer button, Excel automatically switches the spreadsheet (not the workbook) to the Page Layout view.

  • On the View tab, in the Workbook Views group, click Page Layout:
    Page Layout view button in Excel 365

Excel displays the worksheet in Page Layout view, where Excel shows sections Add header and Add footer:

Page Layout view in Excel 365

Note:

You can also click Page Layout view Page Layout View in Excel 365 on the status bar to display this view:

Page Layout view in status bar Excel 365

Headers and footers in the Page Layout view have three sections: left, center, and right. Also, after activating any of these sections, Excel displays the Header & Footer tab on the Ribbon:

Header and Footer tab in Excel 365

To create different headers and footers for odd and even pages, follow these steps:

   1.   On the Header & Footer, in the Options group, select the Different Odd & Even Pages checkbox:

Different Odd and Even Pages in Excel 365

Word names the headers Odd Page Header and Even Page Header, and the footers correspondingly, so you can easily see which one you edit.

   2.   Click in the Odd Page Header area or Odd Page Footer area, and create the header or footer you want for odd-numbered pages:

Odd Page header in Excel 365

   3.   Move to the Even Page Header area or Even Page Footer area and create the header or footer for the even-numbered pages:

Even Page header in Excel 365

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more