Print Different Headers for Odd and Even Pages in Excel

Add to Favorites

How to print pages in Excel with different headers for odd and even pages.

Steps

Go to the View tab and click the Page Layout button on the left.

e7bd3d7993afd26ec929ee7852493f90.jpg

The spreadsheet will then change to look like it will when you print it.

Click at the top of the page to add a Header or the bottom to add a footer.

Once you have clicked in the header or footer, look to the Ribbon menu on the Design tab (which should appear when you clicked the header or footer). In the Options section, check next to where it says Different Odd & Even Pages.

43d14da9f3c4a964df5fdceb297b1857.jpg

Once you click this, you will notice additional text at the header and footer. It will say Odd Page Header or Odd Page Footer for the odd pages and Even Page Header or Even Page Footer for the even pages.

Now, whatever you type on a header/footer for an odd page will appear on all the odd pages and the same goes for the even pages.

In this example, I simply wrote "This is an Odd Page." and "This is an Even Page."

Go to the print preview window to check this:

f361375661e4d78c7f2acebd7d9c8ec9.jpg

Notes

When you go back to the normal view for the spreadsheet, you will not see the headers or footers while in Excel. You will only see them while in Print Preview mode, Page Layout View, or when you print the spreadsheet.

Download the attached file to see this example in Excel.


Downloadable Files: Excel File

Similar Content on TeachExcel
Print Specific Pages in Excel
Macro: This free Excel macro allows you to print a pre-specified selection of pages from Excel. T...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Print Specific Rows or Columns on Each Page in Excel
Tutorial: How to repeat specific rows or columns on every printed page so that you know what each c...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...