FREE Excel Tips Newsletter from
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

April 12, 2016

Hi fellow Excel Addict,

Two weeks ago we had 15 cm (6 in) of snow. This past Saturday it was 17C (68F). This morning I woke up to -10C (14F). From what I see on TV, many other regions are also experiencing these crazy extremes in their weather. Thankfully, we rarely ever have any disastrous weather events here.

However, on the bright side, the weather
for the past few weeks has been mostly sunny and great for running. I have been easing back into a running routine (currently at 3:2 intervals) after more than a year and a half off with an injured knee. I watched the Barkley Marathons on Netflix the other night. I wouldn't attempt that in my wildest, craziest dreams.

In last Thursday's 'Excel in Minutes' newsletter, I showed you how to 'Highlight Upcoming Dates in Real Time'. If you missed it you can read it here. Note that I made a correction to that newsletter shortly after I sent it out. The online version has been updated with the corrections.

Hoping you're enjoying your week and I'll be back again on Thursday with my Excel in Minutes tip.

If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.

Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)

Francis Hayes (


I just learned that PivotTable expert, John Michaloudis, is running a FREE webinar this week that will teach you how to create PivotTables.

Learn to create Pivot Table in Excel in this 1-Hour WebinarIf you’ve always wanted to learn PivotTables but found them  overwhelming or even if you already know the basics of Pivot Tables, this 1-hour webinar is going to change all that for you. By the end you’ll be slicing and dicing your data in just seconds using the Pivot Table 'magic tricks' that John is going to teach to you.

Here are just a few of the comments that John has received about his previous webinar...

"Simply awesome, with in an hour I found myself a Pivot expert"

"I would like to say I have been wary and 'scared' of Pivot Tables for years. No longer!"

"Thank you so much for this session. I am new to creating pivot tables but you made it easy to understand."

Find out more about this webinar and choose a date and time to tune in. Please click here. Quote of the Day

"If you want something you've never had,
you must be willing to do something you've never done."
-- Thomas Jefferson --

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

Excel in Seconds with

Avoid Moving to the Next Cell

Most times, when you enter data or a formula into a cell you do want to move to the next cell. However, sometimes you may need to immediately perform another task (i.e. formatting, copying, etc...) with that same cell.

To stay in the same cell rather than having to move back to it, a
simple trick is to hold down the CTRL key as you press Enter. If you haven't used this tip before, you may find it hard to break that old habit. But when you do remember to use it, you'll realize how much more convenient it is.

Avoid Moving To Next Cell in Microsoft Excel 2007 2010 2013 2016 365

Thanks for supporting this newsletter and website

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

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