Move to top edge of data region
Windows shortcut
Ctrl↑
Mac shortcut
⌃↑
If the active cell is empty, Excel will stop on the first non-empty cell above the active cell. If the active cell is non-empty, Excel will stop on the last non-empty cell above the active cell.
On a Mac, the command key (⌘) can be used instead of the control key.
Related videos
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
