January 19, 2017
Hi fellow Excel Addict,
So 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 Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
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.
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;
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.
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.
|"Spreadsheets Tips From An
Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630