Exceljet

Quick, clean, and to the point

This video comes from our online video training for Excel.

How to move around big lists fast

Summary 
A handy shortcut for hopping around large lists or tables. Much faster than scrolling.
Video Transcript 

Today we're going to look at a tip for moving through large lists. So if you have a large list in Excel...hundreds, thousands, or even tens of thousands of rows, it's just not practical to scroll through that list to get to the bottom, or scroll through that list to get to the top. It's just going to take way too long. So wouldn't it be nice if there was a way to just jump to the bottom or the top of that list? Well, there is. You just have to learn the keyboard shortcut.

Let's take a look.

So here we are in Excel, and if I start scrolling, you can see this is a big list. In fact, this list is over 30,000 rows. So it's just not practical for me to scroll to the top or bottom of that list manually.

So, what I can do instead. Is I can put my cursor here on A1, and press control, and the down arrow, and I'll go right to the bottom. Control up arrow, right back to the top. Doesn't take any time at all. Now can also press control right and the arrow and go over to the right edge of the list, and control left arrow, and go back to the left edge. So, basically, I can just ride down to the bottom of a column of text, ride over across the row, ride back up to the top, and ride back over.

I like to think of this as "riding the slide". Just hop into a column full of text or numbers and, using control down arrow, you can go all the way to the bottom. Control right arrow, all the way to the edge. Control up, all the way back to the top. And control left, all the way back over to the corner.

It's important to understand what will happen if your list has blanks in it. So if I take a name here and delete it. And then I go back to A1 and press control down arrow. You'll see that my cursor stops when it gets to that empty cell. Press control down arrow again, we jump over the empty cell and stop when we get to the first cell that's got content. Press control down arrow again, now we go to the bottom. Same thing, on the way back up.

So anytime, you have a blank or an empty cell in your list, you're going to stop if you use this shortcut. So it's important to understand that.

Author 
Dave Bruns
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables