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.
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 drag items manually into your own groups.
In this video, we show you how to apply bold, italic, and underlining styles to text.
Most Excel functions require arguments. In this video, we explain how function arguments and how to use them.
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart.