May 17, 2016
Hi fellow 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
Today'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)
If you missed my last newsletter, you can click here to view it online.
My &%$#@ Tab Key is Scrolling Me One Screen Horizontally!
I 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.
| '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