Windows Mac
Shift← ⇧←

About This Shortcut 

This shortcut extends the selection from the active cell to the cell immediately to the left. If multiple columns are selected to start with, Excel will shrink the selection by moving the entire right edge of the current selection one column to the left.

Related videos

Excel Shortcuts for selecting cells in Excel

Shortcuts for selecting cells in Excel

Excel has many useful shortcuts for selecting cells. This includes shortcuts for selecting rows, columns, groups of cells, and even the entire worksheet. Let’s take a look. When you’re selecting individual cells, you can use the arrow keys to move the selection around. If you hold down the shift key …
Excel Shortcuts for extending selections

Shortcuts for extending selections

In this video, we’ll cover shortcuts for extending selections to include more cells. The most basic way to extend a selection is to use the shift key + any arrow key. From a single cell, this lets you add additional cells in any direction. If you begin with a larger selection, shift will let you …
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.