About This Shortcut

If the active cell is empty, Excel will stop on the first non-empty cell to the right. If the active cell is non-empty, Excel will stop on the last non-empty cell to the right.

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

About This Shortcut

If the active cell is empty, Excel will stop on the first non-empty cell to the left. If the active cell is non-empty, Excel will stop on the last non-empty cell to the left.

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