Move to bottom edge of data region
Windows shortcut
Ctrl↓
Mac shortcut
⌃↓
If the active cell is empty, Excel will stop on the first non-empty cell below the active cell. If the active cell is non-empty, Excel will stop on the last non-empty cell below the active cell.
On a Mac, the command key (⌘) can be used instead of the control key.
Related videos
Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to quickly base one pivot table on another.
A handy shortcut for hopping around large lists or tables. Much faster than scrolling.
A really fast way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
A cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
Download 200+ Excel Shortcuts
Your videos are the best one I have seen so far. I use excel in my advanced acc. techniques course and may be coming back to you for some tailored chosen set of videos. - Joanna
