Jump to the edge of a large data set by using the 'End' key to navigate in Excel. Episode #1227 shows you how!
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in Depth, chapter 7.
Using the End Key for Navigation.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Now, the [ End ] key goes back to the days of Lotus 1-2-3.
Using this trick forever, you can also use [ Ctrl + arrow key ] to do the same thing.
When I press the [ End ] E N D key, on my keyboard.
Look right down here and the status bar says that I'm in End Mode.
And then if I press any [ arrow ] key, I'm going to jump to the edge of the data.
So, I'm currently sitting on a cell, that's non blank When I press [ end ] and then [ down arrow ] I jump down to the bottom of that column.
Great way to get down to the bottom of a data set, provided you have no blanks [ end ] and then [ right arrow ], will take me over to at the right edge of the data.
Now, once you're on the edge of the data, if I would press [ end ] and then [ right arrow ] it's going to jump the gap of blank cells and go to the next filled cell.
So, it really does two different things and [ down arrow ] and, [ left arrow ] will jump the gap.
Alright! Now, I mentioned that the [ ctrl ] and the [ arrow ] keys to the same thing So, [ ctrl ] [ down arrow ], [ ctrl ] [ right arrow ], [ ctrl ] [ right arrow ], [ down arrow ], [ ctrl ] [ left arrow ].
Both jump the gap or ride the range down to the bottom of the filled cells and stop there at the border.
When you have a huge data sets.
You know, with a million records, or 100,000 records.
This is a great way to, very quickly get to the bottom, right, left or top of the data set.
I want to thank you for stopping by.
We’ll see you next time for another netcast, from MrExcel.
Excel in Depth, chapter 7.
Using the End Key for Navigation.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Now, the [ End ] key goes back to the days of Lotus 1-2-3.
Using this trick forever, you can also use [ Ctrl + arrow key ] to do the same thing.
When I press the [ End ] E N D key, on my keyboard.
Look right down here and the status bar says that I'm in End Mode.
And then if I press any [ arrow ] key, I'm going to jump to the edge of the data.
So, I'm currently sitting on a cell, that's non blank When I press [ end ] and then [ down arrow ] I jump down to the bottom of that column.
Great way to get down to the bottom of a data set, provided you have no blanks [ end ] and then [ right arrow ], will take me over to at the right edge of the data.
Now, once you're on the edge of the data, if I would press [ end ] and then [ right arrow ] it's going to jump the gap of blank cells and go to the next filled cell.
So, it really does two different things and [ down arrow ] and, [ left arrow ] will jump the gap.
Alright! Now, I mentioned that the [ ctrl ] and the [ arrow ] keys to the same thing So, [ ctrl ] [ down arrow ], [ ctrl ] [ right arrow ], [ ctrl ] [ right arrow ], [ down arrow ], [ ctrl ] [ left arrow ].
Both jump the gap or ride the range down to the bottom of the filled cells and stop there at the border.
When you have a huge data sets.
You know, with a million records, or 100,000 records.
This is a great way to, very quickly get to the bottom, right, left or top of the data set.
I want to thank you for stopping by.
We’ll see you next time for another netcast, from MrExcel.
