Mynda's Excel Dashboard Webinar

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

May 17, 2016

Hi fellow Excel Addict,

Francis Hayes (The Excel Addict)Two years ago around this time I was getting ready to run my first half-marathon at the Bluenose Marathon in Halifax, Nova Scotia. I'm just a recreational runner, so this was a big deal for me...the longest distance that I had ever run. It turned out great. I finished in a time of 1 hour and 55 minutes which was more than 15 minutes faster than I expected.  However, about two months after that I began having a problem with my knee and didn't run again for more than a year and a half. About 4 months ago I started slowly easing back into running again and so far it's been going pretty well.

My wife and I are scheduled to travel to Halifax this coming weekend as she will be running the 'half' for her fifth time. I haven't progressed quite enough to run a half-marathon yet but last night I decided 'last minute' to register for the 10K race at the Bluenose. This will be my first race in almost 2 years, so I am really looking forward to it. Also, Halifax is a beautiful city as well, so it should be a great getaway weekend.

Excel in Seconds
oday's 'Excel in Seconds' tip was prompted by a frustrating problem I encountered just last week. In more than 20 years of using Excel, this is the first time it has happened to me. However, when I checked online I discovered that this is a common issue with Excel users.

Excel in Minutes
In last Thursday's 'Excel in Minutes' tutorial, I showed 'How to Fill Blank Cells With The Values From Above'. Many readers emailed me to say what a fantastic tip it was and how it will save them lots of time. Although, those steps to fill blank cells are pretty easy and take only a minute or so, if you want to kick it up a notch, a macro can be used to complete the entire process in just a couple of seconds. I have updated the online version of this tip to include the VBA code you will need for this. You can find it here.

If you have a favourite tip that you'd like to share, or have a suggestion for a tip you would like me to include in a future newsletter, please send it along to me.

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

Francis Hayes ( Quote of the Day

"Running has given me the courage to start,
the determination to keep trying,
and the childlike spirit to have fun along the way.
Run often and run long,
but never outrun your joy of running."

-- Julie Isphording --

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

Excel in Seconds with

My &%$#@ Tab Key is Scrolling Me One Screen Horizontally!

Lotus Transition in Microsoft Excel 2007 2010 2013 2016 365I don't know how it happened but a couple of days ago something weird AND VERY ANNOYING started happening.

Every time I pressed my Tab key, it scrolled and selected a cell one full screen to the right. I often use my Tab key to move one cell to the right...maybe as often as I use the arrow key. I soon realized how often I do use my Tab key. It was getting so annoying.

That was bad enough but then I found that every time I pressed CTRL+SHIFT+right arrow it selected the range of cells from my active cell (A2) over one screen to the right (A2:AD2), when it should have selected only as far as the last cell in the range (A2:E2).
CTRL+right arrow showed the same behaviour as the tab key. It too scrolled and selected a cell one full screen to the right and my CTRL+SHIFT+down arrow shortcut didn't work at all. Grrrrr!

Although this had never happened to me in more than 20 years of using Excel, a quick Google search revealed that it is a common issue for Excel users. Luckily, the solution is pretty simple.

The problem is caused by the Lotus transition settings.

If you ever run into this problem, keep calm and follow these steps to fix it...

From the File tab (Office button for Excel 2007), goto Options, click the Advanced tab on the left then scroll down to the bottom of the dialog. You will see a 'Lotus compatibility' section. Clear the 'Transition navigation keys' option and if any of the other Lotus Compatibility options are checked, I recommend clearing those as well.

It worked for me, so now I'm calm again.

Turn Off Lotus Transition Keys in Microsoft Excel 2007 2010 2013 2016 365

Mynda's Excel Dashboard Webinar
Thanks for supporting this newsletter and website

REE 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