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.

Related videos

The videos below demonstrate this shortcut.
In this video we show you how to select one or more cells, including cells that are not next to one another.
In this video we show you how to find all matches at the same time.
In this lesson, we cover shortcuts you can use to select cells.
In this video, we'll look at different ways to remove a table from an Excel worksheet.
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.

Download 200+ Excel Shortcuts

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

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas