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'll look at how to plot average daylight hours per month in a chart, using sunrise and sunset data.
In this video, we show you how to apply bold, italic, and underlining styles to text.
In this video, we'll look at some tips and tricks for using the SUM function, one of the most widely used functions in Excel.
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.