Hey, welcome back to the Mr. Excel net cast episode #952 February 17 it’s my birthday today.
All right, hey, great tip today. I learned this tip when I was doing a seminar in Madison, Wisconsin. Laura was there and gave this great navigation tip although I want to talk first about how to jump to the end of a spreadsheet or end of a data range actually.
Now, going back the days of Lotus 123 you could use the end key END press the end key and then press any arrow key. I’ll press end and then down here, and you see that I jumped from cell A1 down to the edge of the data set. And certainly if I'm somewhere in the middle I’ll press end right I’ll get to the right edge and then I can press END and the right arrow again to jump the gap and end up at the next data set. So this is a great way to very quickly get to the last row.
Now they got you here is that if there's a blank cell it stops the blanks, so and in down will stopped right before the blank cell?
Now for the people who started in Excel instead of Lotus you might use the control and the down arrow keys, so control down arrow. It’s like pressing END down, control up arrow, control right, control left and those will also jumped the gaps, so control right arrow gets me at the right edge, control right arrow will jump the gap.
Now here is Laura's trick. Laura said, “Did you know you that if you double click any edge of the current cell it will do the same thing, so if you’re a mouse person you know you have a great way to replicate this keyboard navigation. So if I double click on the bottom it will jumped out to the end. If I double click on the right it will jump to the right edge, double click on the left it will jump to the left.
I thought that was so cool, I always love when there's some little navigation tricks that I have discovered in someone in one of my seminars I showed you.
Now the one difference with this if I'm at the right edge of the data and I control, click on the edge it takes me to right before the data instead of actually jumping to the cell. Control down will it take you to column line in this case it doesn't.
Now you know the interesting thing here so I learned something new, and you know that became my Facebook desk. Hey, did you know if you double click the bottom edge, you know it will do this and a great trivia pops in first and greets such a keyboard person you never know when to discover that. But then two other folks Beth Milton and Carrie Whiteford both were unhappy with this because they missed double clicking the fill handle and hit the bottom edge and for them it's very frustrating thing. So you know curios on that, be nice if I can shut off this feature.
So for me, I though it’s a great new way faster where you get to the bottom of the data say especially here your hands already in the mouse. A good way to go although Beth and Carrie pointed out that it’s a little bit annoying when it does it and you didn’t expect it to do it.
So try that out, thanks for Laura from I think Waukesha, Wisconsin for that cool Excel tip. I’ll get you next time for another net cast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services