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.
Most Excel functions require arguments. In this video, we explain how function arguments and how to use them.
In this lesson, we cover shortcuts you can use to select cells.
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.
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.
In this video we show you how to apply bold, italic, and underlining styles to text.

Download 200+ Excel Shortcuts

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