FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 16, 2016

TheExcelAddict.com Quote of the Day

"Using the power of decision gives you the capacity to get past
any excuse to change any and every part of our life in an instant."
-- Anthony Robins --


Hi fellow Excel Addict,

I appreciate you joining me today for another 'Excel in Seconds' time-saving tip that I hope will help you get your work done faster and smarter.

If you missed Thursday's tip where I showed you a couple of  'Across-Then-Down Data Input Techniques', you can still 
find here.

Whenever you need to starting the page numbering on your reports with something other than the default 'Page 1', t
oday's tip will show you how, in just seconds.

Here's our latest 'temporary' snowfall. We had a big storm last Saturday, as you can see from the picture. And just like all other snowfalls so far this winter, this one will be followed by warm temps and rain. So by Wednesday night, I expect that all of the snow will melted...again.

Francis Hayes (TheExcelAddict.com)
It may be only 5 weeks to spring in Canada but I'm not looking for the crocuses just yet.

Hope you enjoy the rest of your week.

As always, please feel free to share this newsletter with anyone else you think it may help.


Take care and keep Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)



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



Take you Excel reporting to a whole new level
Learn Excel Dashboard Reporting
Free Excel Dashboard Webinar
See Excel Dashboards in action and learn how to create an interactive Excel Dashboard...for FREE?

Mynda's Excel Dashboard Reporting Course



Excel in Seconds with TheExcelAddict.com

Change the Starting Page Number for Your Footer


Some companies create reports by combining information from different documents. It may be that the first several pages of a quarterly report are more narrative and are created in MS Word. The financial section of the report, obviously, comes from Excel.

When you print a report from Excel, normally the page numbering begins at page 1. So, for example, if the first 3 pages of the quarterly report are printed from Word and the last 10 pages are printed from Excel, you may want to have the page numbers from Excel to start with 4. So your final report will include pages 1 to 3 printed from Word and 4 to 17 printed from Excel.

There is a setting in Excel that allows you to change the starting page number for your printed reports. It's been there as long as I can remember but it's so easy to overlook.

Here's how to change the first page number printed in your footer (or header)...

1) Click the Page Layout tab and click the small arrow in the bottom right corner of the Page Setup group. (Alternatively, you can click the Print Titles command to open the Page Setup dialog.
Or, if you like keyboard shortcuts, you can press ALT,P,S,P to go directly to the Page tab in the Page Setup dialog.)

2) On the Page tab, you will find the 'First page number' option on the lower left of the dialog. By default, the value is set to Auto, but you can enter a number here that you want the page numbering on your printed report to start at;

Change Starting Page Number In Footer_in_Microsoft_Excel_2007_2010_2013_2016_365

3) Go to the Header/Footer tab and make sure you have your header or footer set to print the page numbers;
 
3) Click OK.

Total Page Numbers Not Adjusted for Change to First Page Number
Since the total Page #s value in the footer doesn't adjust if you change starting page number, to show the total page numbers being printed in the footer (e.g. Page 4 of 13), you will need to manually type that number in the footer.
Footer Total Pages Number Manually Adjusted_in_Microsoft_Excel_2007_2010_2013_2016_365


Mynda's FREE Excel Dashboards Webinar

Thanks for supporting this newsletter and website


Earnings 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' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630