Add adjacent cells to selection

Windows	Mac
ShiftClick	⇧Click

About This 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.

Video thumbnail for How to add a slicer to a table

Excel Tables

3:16

How to add a slicer to a table

Video thumbnail for How to add a slicer to a pivot chart

Core Charts

2:11

How to add a slicer to a pivot chart

Video thumbnail for How to remove an Excel Table

Excel Tables

3:08

How to find all matches at once in Excel

Author

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.

This is the most easy to understand demo of VLOOKUP I've ever come across. Thanks!

Tawhid

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles