Exceljet

Quick, clean, and to the point

Add adjacent cells to selection

Windows shortcut 
ShiftClick
Mac shortcut 
⇧Click

Hold down the shift key and click elsewhere on the worksheet to extend the current selection to include adjacent cells.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to add a slicer to a table
In this video, we'll look at how to add one or more slicers to an Excel table. Slicers let users filter data with large, friendly buttons.
Shortcuts for selecting cells
In this lesson, we cover shortcuts you can use to select cells.
How to add a slicer to a pivot chart
In this video, we'll look at how to add a slicer to a pivot chart. Slicers provide a powerful way to filter data interactively, and they are a key building block of many dashboards.
How to select cells in Excel
In this video we show you how to select one or more cells, including cells that are not next to one another.
How to find all matches at once in Excel
In this video we show you how to find all matches at the same time.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.