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

January 26, 2017
Greetings from The Excel Addict

Hi fellow Excel Addict,

Francis Hayes (The Excel Addict)Thanks for joining me again. I believe there is almost always an easier and better way to do just about anything in Excel -- if you're willing to dig a little deeper.

I hope you find ideas in my newsletters that help make your work a little easier and enjoyable. I also hope that I have convinced you to not settle for doing things a certain way just because 'that's the way they've always been done'. I've heard that comment way too many times over the years. Don't ever stop looking for ways to improve.

Do you have co-workers or maybe even bosses who are afraid of using innovative ways to improve long-standing processes? Those people drive me CRAZY! Do you have a story of how you have made significant improvements in your company's processes by refusing to stay stuck in outdated practices. Please share your story with me. I would like to publish some of them in a future newsletter. And I promise I won't reveal your identity.

In today's 'Excel in Minutes' tip I'm going to show you how you can use 'Custom Formatting for Your Headers and Footers'.

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

"Don't let your learning lead to knowledge.
Let your learning lead to action."
-- Jim Rohn
If you have a favourite quote, send it to me and I may post it in my newsletter.

Excel in Minutes with

Custom Formatting for Your Headers and Footers

You DO know that you can change the formatting for your headers and footers don't you? This is another of those Excel features that I have been using for ever, so I assume that everyone else knows about it as well. But many Excel users don't realize that this feature exists.

If you are 'old school' like me and have been using the Page Setup dialog for years to create your headers and footers, it is not obvious that you CAN change their formats. So, if you choose a footer from the predefined dropdown list in the Page Setup dialog, Excel uses your workbook's default font and also aligns it to the center of the page. There doesn't appear to be a way to change that.

Choose a Predefined Header Footer in Microsoft Excel 2007 2010 2013 2016 365

However, when you click either the Custom Header... or Custom Footer... buttons, you get to choose which section (i.e. left, center, or right) to place your header or footer in. You can type directly into either of the sections, you can click the buttons above to insert information related to your workbook (i.e name, folder, date, etc...) or you can use a combination of both.

If you want to change the formatting of your footer from the default font, use the Format Text button, the one with the letter A. You simply select all or part of your footer, then click the Format Text button and choose the formatting you want.

Format Font Headers And Footers in Microsoft Excel 2007 2010 2013 2016 365
This gives you complete control over how you want your headers and footers displayed.

Header & Footer Tools Tab
I find it strange that Microsoft chose not to put the headers and footers option on the Page Layout tab. So, if you have discovered that the option to insert headers and footers is on the Insert tab, you know that formatting your headers and footers is as simple as formatting any other part of your worksheet. Simply enter your header or footer, select the part you want to format and choose the formatting options from the Ribbon.

Insert Tab Format Header Footer in Microsoft Excel 2007 2010 2013 2016 365

Exiting the 'Headers & Footers Tools' tab
Since I rarely use the Headers & Footers Tools tab (that appears when you click Insert, Header & Footer), whenever I do I always get stuck in this tab. There isn't any obvious way to close this tab and return to the normal worksheet view. The only solution I have found is to click the Normal
icon on the right side of the Status Bar.

Alternatively you can click away from the header or footer area and into the worksheet area, then from the View tab, click Normal in the Worksheet views section.

Workbook Views in Microsoft Excel 2007 2010 2013 2016 365

Understand both ways
If you use only one of the methods above (the Page Setup dialog or the Insert tab) to create your headers and footers, try using the other one to see how it works. Only by practicing these methods will you have a fuller understanding of the many options that Excel makes available to help you achieve your goals.


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