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.

Core Excel

2:43

How to find all matches at once in Excel

Video thumbnail for How to remove an Excel Table

Excel Tables

3:08

How to add a slicer to a table

Video thumbnail for Shortcuts for selecting cells

Excel Shortcuts

2:27

How to add a slicer to a pivot chart

Core Excel

2:21

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.

Hey, no question, I just wanted to let you know that your site is amazing and has helped me out so much. Thank you for maintaining such a great resource! It warms my heart to know this is something you accomplish with your partner.

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