January 26, 2017
Hi fellow 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 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.
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.
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.
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.
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.
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.
|"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