Laura from Wisconsin provides today's cool Excel trick: Double click any edge of the active cell and Excel will jump to the edge of the data. Episode 952 shows you how.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Basically you start out with massive amounts of data.
So how we're going to analyze as well let's fire up a pivot table.
Lets see if you can solve this problem.
Hey, welcome back to the Mr. Excel netcast. Episode no 952 February 17th.
It's my birthday today alright. 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 to 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 arrow, and you see that I jump from Cell A1 down to the edge of the data set and similarly if I'm somewhere in the middle, I 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 the gotchu here is that if there's a blank cell it stops at the blank cell.
So end and down will stop 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 key So control down arrow is like pressing end down control up arrow control right, control left and those will also jump the gap. So control right arrow gets me to the right edge, control right arrow will jump the gap.
Now here is Laura's trick, Laura said.
Did you know 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 now have a great way to replicate this.
keyboard navigation So if I double-click on the bottom it will jump down to the end.
If I double-click on the right it'll jump to the right edge.
Double-click on the left, It will jump to the left edge. I thought that was so cool.
I always love when there's some great little navigation trick that I haven't discovered and someone in one of my seminars shows me.
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 arrow with what have taken me to column I in this case it doesn't.
Now you know an interesting thing here, so I learned something new and you know that became my Facebook status.
Hey, did you know if you double-click the bottom edge, you know it will do this and have Greg Turby pops in first and Greg says, well he's such a keyboard person he never would have discovered that.
but then two other folks Beth Melton and Gary Whiteford both were unhappy with this because they miss double-clicking the fill handle and hit the bottom edge and for them it's a very frustrating thing so you know Gary said that'd be nice if I could just shut off this feature.
So for me, I thought a great new way.
Fast way to get to the bottom of the dataset especially if your hands already on the mouse a good way to go although Beth and Gary pointing out that it is a little bit annoying when it does it and you didn't expect it to do it. So try that out.
Thanks to Laura from I think Waukesha Wisconsin for that cool excel tip .
Get you next time for another netcast from MrExcel.
Thanks for stopping by. Will see you next time for another netcast from MrExcel.
Basically you start out with massive amounts of data.
So how we're going to analyze as well let's fire up a pivot table.
Lets see if you can solve this problem.
Hey, welcome back to the Mr. Excel netcast. Episode no 952 February 17th.
It's my birthday today alright. 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 to 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 arrow, and you see that I jump from Cell A1 down to the edge of the data set and similarly if I'm somewhere in the middle, I 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 the gotchu here is that if there's a blank cell it stops at the blank cell.
So end and down will stop 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 key So control down arrow is like pressing end down control up arrow control right, control left and those will also jump the gap. So control right arrow gets me to the right edge, control right arrow will jump the gap.
Now here is Laura's trick, Laura said.
Did you know 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 now have a great way to replicate this.
keyboard navigation So if I double-click on the bottom it will jump down to the end.
If I double-click on the right it'll jump to the right edge.
Double-click on the left, It will jump to the left edge. I thought that was so cool.
I always love when there's some great little navigation trick that I haven't discovered and someone in one of my seminars shows me.
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 arrow with what have taken me to column I in this case it doesn't.
Now you know an interesting thing here, so I learned something new and you know that became my Facebook status.
Hey, did you know if you double-click the bottom edge, you know it will do this and have Greg Turby pops in first and Greg says, well he's such a keyboard person he never would have discovered that.
but then two other folks Beth Melton and Gary Whiteford both were unhappy with this because they miss double-clicking the fill handle and hit the bottom edge and for them it's a very frustrating thing so you know Gary said that'd be nice if I could just shut off this feature.
So for me, I thought a great new way.
Fast way to get to the bottom of the dataset especially if your hands already on the mouse a good way to go although Beth and Gary pointing out that it is a little bit annoying when it does it and you didn't expect it to do it. So try that out.
Thanks to Laura from I think Waukesha Wisconsin for that cool excel tip .
Get you next time for another netcast from MrExcel.
Thanks for stopping by. Will see you next time for another netcast from MrExcel.
