Extend the selection to the last cell left
Windows shortcut
CtrlShift←
Mac shortcut
⌃⇧←
If the active cell is empty, Excel will extend the selection to the first non-empty cell to the left. If the active cell is non-empty, Excel will extend the selection on the last non-empty cell to the left. On a Mac, the command key (⌘) can be used instead of the control key.
Related videos
The videos below demonstrate this shortcut.
In this lesson, we'll show you how to use conditional formatting and a forumula that uses the LEN function to highlight text that is too long.
In this lesson, we cover shortcuts you can use to extend selections.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.