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'll look at different ways to remove a table from an Excel worksheet.
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 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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.