Add non-adjacent cells to selection

Windows	Mac
CtrlClick	⌘Click

About This Shortcut

Hold down the control key and click (or click and drag) elsewhere on the worksheet to add another range of calls to the current selection.

Related videos

The videos below demonstrate this shortcut.

Video thumbnail for How to add slicers to a pivot table

Core Pivot

3:14

How to add slicers to a pivot table

Video thumbnail for How to use function arguments

Core Formula

3:08

Ways to filter data in a chart

Video thumbnail for How to format font and font size in Excel

Core Excel

3:05

How to format font and font size in Excel

Video thumbnail for How to chart generations with floating bars

Core Charts

3:37

How to chart generations with floating bars

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 site has some of the best and most informative tutorials out there. Dave's courses are concise and to the point. They are extremely easy to learn based on his method of instruction. they are well worth the money spent.

Sam

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