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 build a chart with multi-level axis labels. A multi-level axis allows you to group related information together.
In this video, we'll look at a few ways to filter out data you don't want to see in a chart.
In this video, we show you how to select one or more cells, including cells that are not next to one another.
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 show you how to apply bold, italic, and underlining styles to text.