The Excel Addict - Help with Excel 2013, 2010,
2007, 2003

January 19, 2017
Greetings from The Excel Addict

Hi fellow Excel Addict,

Francis Hayes - TheExcelAddict.comSo far, winter has been pretty kind to us here in Newfoundland. But that's about to change today. Although winter officially started a month ago, it usually doesn't get nasty until late January or early February. Well we've got a monster storm heading our way today. Upwards of 50 cm (20 in.) of snow and bitterly cold northerly winds of 100 kmh (60 mph).

Bring it on!

In today's 'Excel in Minutes' tip I'm going to show you how you can 'Print Different Headers and Footers for Odd and Even Pages'.

If you missed my 'Excel in Seconds' newsletter on Tuesday, I showed you how to 'Show the Actual Formula Not the Result'. You can read that tip here.

I hope you have a great weekend and keep on Excelling,

Keep on
Francis Hayes (The Excel Addict)
Email:  fhayes[AT]


If you missed my last newsletter, you can click here to view it online.

Quote of the Day

"There are only 3 things that can make your dreams come true:
your thoughts, your words, and your actions."

-- Mike Dooley
If you have a favourite quote, send it to me and I may post it in my newsletter.

Excel in Minutes with

Print Different Headers and Footers for Odd and Even Pages

If you print any of your Excel reports double-sided, for example for binding into booklets, you may have wondered how to have the headers or footers (e.g. page #, name, date, etc...) printed on the left side of odd pages and the right side of even pages, the way most books do.

Print different headers and footers on odd and even pages

If you use a left footer and print your report double sided, scanning through the page numbers when they are bound together is more difficult because the odd page footers are now on the inside of the booklet page.

Of course, you can use center headers or footers and you won't have that problem. But If you want your headers or footers to print differently on odd and even pages, there is a Page Setup option that most Excel users overlook.

1) From the Page Layout tab, click PrintTitles to open the PageSetup dialog;

2) Click the Header/Footer tab;

3) You may not have ever noticed that option, 'Different odd and even pages', in the lower section of the dialog before. Select it now;

3) Click the Custom Header or Custom Footer button and you will see that there are now two tabs at the top of the dialog; one for odd pages and one for even pages.

4) Click the Odd Page tab and insert a footer (or header) in the right section;

5) Click the Even Page tab and insert a footer (or header) in the left section;

Page Setup Option For Odd And Even Headers And Footers in Microsoft Excel 2007 2010 2013 2016 365
6) Click OK, then OK to close the Page Setup dialog.

Now when you print your report, your footers (or headers) will print on the outer edge of the pages in a double sided booklet.

Left, Center, Right
Note that you are not restricted to using the left and right sections for your headers and footers. For example, for the odd pages you may want to put the report name in the left section and page numbers in the center section and for even pages put the report name in the right section and page numbers in the center section.

Different Section Headers For Odd And Even Pages in Microsoft Excel 2007 2010 2013 2016 365

Take a look at some books and notice how the headers and footers are designed. You should be able to replicate any version of these in Excel.

If you've found this tip helpful, please share it.

Click here to get more tips like this every week

Thanks for supporting this newsletter and website

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of
Copyright Francis J. Hayes All Rights Reserved.

8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630