About This 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 control key (⌃) can be used instead of the command key (⌘).

About This Shortcut

It doesn’t matter whether cells contain data or not.