Exceljet

Quick, clean, and to the point

Add non-adjacent cells to selection

Windows shortcut 
CtrlClick
Mac shortcut 
Click

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.
In this video we show you how to find all matches at the same time.
Most Excel functions require arguments. In this video, we explain how function arguments work and how to use them.
In this video we show you how to apply fonts and control font size.
In this video we'll look at how to use the CONCATENATE function, an alternative to using the ampersand (&) character to join values in a formula.
In this video, we'll look at how to plot average daylight hours per month in a chart, using sunrise and sunset data.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.