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.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
How to use function arguments
Most Excel functions require arguments. In this video, we explain how function arguments and how to use them.
Shortcuts for selecting cells
In this lesson, we cover shortcuts you can use to select cells.
How to use the SUM function
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.
How to filter chart data with a table filter
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.
How to apply bold, italic, underlining styles in Excel
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.