Save yourself hours with these tips and tricks for Microsoft Excel 2003, 2007, 2010, 2013, 365

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

October 20, 2015

"Don't start your day with the broken pieces of yesterday.
Every day is a fresh start. Each day is a new beginning.
Every morning we wake up is the first day of our new life."
-- Unknown Author

Hi fellow Excel Addict,

oday in Canada, we have a new prime minister and our beloved Toronto Blue Jays are back in the running in the American League Baseball Championship Series. A great start to the week.

Another great start to the week is a shortcut
that you are going to learn today for something that most Excel users frequently need to do but very few know about.

If you're not Canadian, the first two topics may not have much impact on you but I hope that today's tip does.


Excel Dashboard Course

Enjoy the rest of your week and keep on Excelling,
Francis Hayes (The Excel Addict)

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

To update your contact info, click the 'Change Subscriber Options' at the bottom of this email.

Excel in Seconds with

Easily Copy Print Settings From One Worksheet to Another

When you make a copy of a worksheet tab in Excel by holding down the CTRL key and dragging the sheet tab, the print settings get copied as well. However, if you want to copy just the Print Settings from one sheet to one or more other sheets, there doesn't appear to be an option to do that.

But there is! In fact, there is a VERY SIMPLE , EASY and FAST way to do this that most Excel users have never heard of.

1) First, select the sheet tab whose print settings you want to copy;

2) Hold down the CTRL key and click each sheet tab you want to copy the print settings to;

3) From the Page Layout tab, click Print Titles (to open the Page Setup dialog), then simply click OK (or press ENTER).

4) Last VERY IMPORTANT step:  Right click any sheet tab and click Ungroup Sheets. If you don't do this, you could mess up all of your sheets because everything you do to one sheet will be duplicated in all other grouped sheets.

Copy Print Settings From One Worksheet To Another in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

To see for yourself why Excel Dashboard Reporting skills are in such high demand by employers, watch Mynda's Excel Dashboards Webinar.

If you decide to enroll in Mynda's full Dashboards Course, you can save 20% off until October 22. Also, use EXCELADDICT for your coupon code at the Checkout and you will qualify for my exclusive 'Excel in Seconds' e-book (COMING SOON) containing 100 quick tips and shortcuts that will take you only seconds to learn but save you hours and hours of work, week after week, month after month, and year after year.

Excel Dashboard Course

Thanks for supporting this newsletter and website

Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter.

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit or send a blank email to theexceladdict(AT)
3)  Post a link to in a company newsletter or 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
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630