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 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 the different underlining options in Excel work.
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 change font color, and demonstrate how Excel's live preview can help you select a color.
When plotting unsummarized data, the chart filter may not be convenient. In this video, we'll look at how to filter larger sets of data in an Excel Table with filters applied.