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,
Today 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.
WEBINAR LINK AND EXCELADDICT DASHBOARD BONUS (see below)
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.
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.
LAST CHANCE FOR FREE DASHBOARD WEBINAR
To see for yourself why Excel Dashboard Reporting skills are in such high demand by employers, watch Mynda's Excel Dashboards Webinar.
EXCEL DASHBOARD COURSE
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 BONUS...my '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.
| 'Spreadsheets Tips
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