If the active cell is non-empty, Excel will stop on the last non-empty cell above the active cell.

On a Mac, the control key () can be used instead of the command key ().

The videos below demonstrate this shortcut.

Video thumbnail for Shortcuts to navigate worksheets

Video thumbnail for How to quickly remove blank rows

Video thumbnail for How to move around big lists fast

Video thumbnail for How to quickly remove rows that have empty values

Video thumbnail for How to do a two-way lookup with INDEX and MATCH

Video thumbnail for Use a throwaway chart to sanity check data