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 ().
Related videos
The videos below demonstrate this shortcut.
Move to bottom edge of data region
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 (⌘).
