Quick, clean, and to the point

Add adjacent cells to selection

Windows shortcut 
Mac shortcut 

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 lesson, we cover shortcuts you can use to select cells.
In this video, we show you how to find all matches at the same time.
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.
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.
In this video, we'll look at different ways to remove a table from an Excel worksheet.