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 the different underlining options in Excel work.
Most Excel functions require arguments. In this video, we explain how function arguments and how to use them.
Table slicers have a variety of settings. In this video, we'll look at how to configure available options.
In this video, we show you how to find all matches at the same time.
In this video, we'll look at how to use the COUNT function to count cells that contain numeric data.