Microsoft Excel 2003, 2007, 2010, 2013 Tips
The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
September 24, 2015

Greetings from The Excel Addict
Hi fellow Excel Addict,

Francis Hayes - The Excel Addict - www.TheExcelAddict.comWelcome to the first day of Autumn (it is, here in the northern hemisphere). I hope you're having a great week too. So far, our September weather here in eastern Newfoundland has been fantastic. I'm starting to like this retirement thing...being able to go out an enjoy the nice weather whenever I want.

Yes, it's nice to be in control of my own time but with that comes a need for discipline to get work done that needs to be done. On beautiful warm days like today, that can sometimes be difficult. So here I am again, late at night putting the finishing touches on my newsletter.

If hope you'll find today's tip helpful.

Take care and enjoy the rest of your week,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



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

You can access even more tips on my website by going to my members' page



If you have a favourite quote, send it to me and I may post it in my newsletter.
"THE MEANING OF LIFE IS TO FIND YOUR GIFT. THE PURPOSE OF LIFE IS TO GIVE IT AWAY." - Pablo Picasso


Today's Microsoft Excel Tip

Custom Footers For All

Here's one habit I developed way back in my early days of Excel that I have stuck with and it has been a life-saver many times.

Sometimes we learn a cool new tip that we know can help us but quickly go back to our old habits. The nice thing about this tip is that, once you set it up, you don't even have to remember to do it, it's automatic.

This tip is about always knowing where the workbook that produced a report is located, when it was printed and who created it.

Have you ever had different versions of a printed report in your hand and couldn't tell which one was the most recent? How you ever you wondered which workbook generated a particular report? And how many times have you asked
, "Who prepared this report?".

To avoid problems like these, I recommend printing a footer on all of your worksheets that shows the file path, workbook name, date, time and the name of the report owner. That way, you'll have this information for all your printed reports. 


To add this custom footer to your worksheet...

1) From the Page Layout tab, click on the small (dialog launcher) arrow on the bottom right corner of the Page Setup group (or you can click the Print Titles command) to open the Page Setup dialog;

Keep track of your files with custom footer info
2) Click the Header/Footer tab in the Page Setup dialog;

3) Click in the section of the footer where you want your footer to print (I always use the right section);

4) Click on the File Path button (this includes the path and the filename);

Page Setup Custom Footer Buttons in Microsoft Excel 2003, 2007, 2010, 2013, 365

5) Press the ENTER key to move down to the next line;

6) Click the Date button then type a blank space, and click the Time button;

7) Press the ENTER key to move down to the next line;

8) Type the text you want to use to identify the report owner/preparer (e.g. Report Owner: Francis Hayes);

Keep track of your files with custom footer info
9) Now, select all of the text in that footer section and click the Format Text button to choose the font format you want to use. I prefer to use a small text size, maybe 7 or 8, and a medium gray color so that the footer is inconspicuous on the report but is still legible.

Format Text In Custom Footer in Microsoft Excel 2003, 2007, 2010, 2013, 365

Sample Report With Custom Footer in Microsoft Excel 2003, 2007, 2010, 2013, 365

Now, you wouldn't want to have to manually add this footer every time you create a worksheet, so to automate this step, you will need to add this custom footer to your default workbook and worksheet templates.

Custom worksheet and workbook templates enable you to add customizations (default font, margins, print settings, etc...) that will be included with all new worksheets and workbooks.

If you haven't previously created custom worksheet and workbook templates, here's an earlier tip, "Create Custom Default Worksheet And Workbook Templates",  I published earlier this year that shows you how.

Maybe you might even consider recommending this tip for your entire office staff so that it's easy for everyone to know where, when and who all reports come from.

P.S. Note that this new custom footer will be automatically added to all new worksheets, however, for your existing files you will need to do it manually.
.



Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or 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 for a few dollars. 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 I will get your money back for you...GUARANTEED. You can't lose.
"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