Microsoft Excel 2003, 2007, 2010, 2013 Tips

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

To view this newsletter in your browser click here.

August 16, 2016

Hi {!firstname_fix},

Francis Hayes - TheExcelAddict.comIn Newfoundland, our summers are pretty short. July is usually pretty dependable for nice weather but August can be a hit or miss. This year however, we have had really nice weather in July and so far in August, except for a couple of wicked days of wind, rain and cold in the first week of August.

So it's with a little hesitance that I am sitting back in front of my computer today while the sun is shining warmly and brightly outside. Yes, I am an Excel addict but in this part of the world we really do appreciate every warm day we get.

Over the past three weeks I have been so busy doing 'vacation stuff' that I've barely had time to sit down at my computer. I have read all of my emails and responded to a few (with easy answers) but not much Excelling.

My Tely 10 story
Since my last newsletter on July 21, I ran the Tely 10 Road Race and was really pleased that I beat my previous best time. There is an interesting story behind that result. Since I had started running only 6 months previous, after being out with a knee injury for 18 months, I was hoping I could at least tie my previous best Tely 10 time of 88 minutes. Everyone kept telling me to 'take it easy and don't injure yourself again'. But secretly my goal was to beat my previous best time by 2 minutes (i.e. 86 minutes) because that's what I had done in my previous two Tely 10s. On race day, my wife and I arrived at the start of the race and that's when I discovered that...

The Excel Addict
...I had forgotten my watch.

Now I had to run the 16 km. (10 mi.) race that I had been training for for months without a clue as to my time. If you are a runner you probably have had runs where you've given everything and the end of the race is a blur. That was me. I didn't even notice the time as I crossed the finish line. I had no idea what my finish time was until an hour later when the results were posted. I believe that if I didn't forget my watch that morning, my time may have been 5 minutes slower.

Cape to Cabot
I was so stoked after my Tely 10 experience that I registered for the Cape to Cabot 20km race in October. This is a race that I've always said that "you'd have to be crazy to run".

Well, you can call me crazy.

The C2C has been called "The Toughest Race in Eastern North America". The race starts just below the lighthouse at Cape Spear National Historic Site, the most easterly point in North America, and climbs and descends three major hills (100m/328ft, 127m/417ft, 206m/675ft) before reaching the waterfront of historic old St. John's. Then it's just one more mile to go, all uphill (151m/495ft)!

Cape To Cabot Race Map St. John's Newfoundland
To get an idea of what the race will be like, I ran the first 10km (including the first 3 big hills) a couple of weeks ago and the second 10km, ending at the top of Signal Hill, last week. I'm happy to say that I didn't have any problems with my two runs, but combining them into one race is another story. I've got two months from today to be ready.

Traveling Excel Addicts
Also, last week I was also very honoured to meet a couple of my Excel Addict subscribers, Dwayne and Patti Cartwright from Texas, who were touring Newfoundland in their 'home on wheels'. I stopped by to visit them at a local campground and we chatted for about an hour. I always love receiving emails from fellow Excel Addicts but meeting them in person was awesome. Patti and Dwayne told me they are thoroughly enjoying their visit to Newfoundland and I wished them safe traveling.

So, that's what I've been doing for the past few weeks.

I hope you don't mind my long email today. Thought you may be wondering where I had been for the past 3 weeks.

Tell others about my newsletter
If you find my Excel tips helpful, please feel free to share my newsletter with your friends—chances are they will too.

If you missed last 'Excel in Minutes' tip (from 3 weeks ago), 'How to Copy Formulas And Keep Cell References From Changing', you can read it here now.

Wishing you a great week end keep on Excelling,
Francis Hayes (The Excel Addict)

P.S. This is your Last chance to register for MYNDA'S EXCEL DASHBOARD COURSE. Learn how to make interactive Excel Dashboards like the one below which is based on Olympics data spanning 1896 to 2012. Actually it's 3 dashboards in one file with tabs (like a browser) to allow you to navigate between them! REGISTRATION CLOSES THURSDAY AUG 18 AT 8 PM (PST)

Microsoft Excel Dashboards Course
Mynda's Excel Dashboard Course Registration

WATCH the DASHBOARD WEBINAR REPLAY: In just 1 hour Mynda will teach you how to build an interactive dashboard. There are still a couple of days left to catch a replay of the webinars before Mynda's Dashboard course registration closes, so if you aren't sure what a dashboard is or how these skills might be relevant to you then click here to watch the replay. In just 1 hour Mynda will teach you how to build an interactive dashboard.

Mynda's Excel Dashboard Webinar Quote of the Day

"Courage is not the absence of fear,
but rather the judgment that something else
is more important than fear."

-- Ambrose Redmoon

To view this newsletter online click here.

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

Get Back to Your Selection

If you have a cell or range of cells selected and scroll to another part of the worksheet, then you want to get back to the selected cells, a shortcut to quickly jump back and still retain your selection is CTRL + Backspace.

Jump To Selected Cell Or Range in Microsoft Excel 2007 2010 2013 2016 365

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 or send a blank email to theexceladdict(AT)

My records show that {!name} at {!email} requested a subscription to this newsletter at on {!signdate long}.

If you would like to share this newsletter with others...
1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed
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