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 add a slicer to a pivot chart. Slicers provide a powerful way to filter data interactively, and they are a key building block of many dashboards.
In this video, we show you how to change font color, and demonstrate how Excel's live preview can help you select a color.
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'll look at how to plot average daylight hours per month in a chart, using sunrise and sunset data.
In this video, we'll take a quick look at the information provided by the status bar. The status bar provides real-time data about currently selected cells and can give you a lot of useful information.