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 show how this shortcut can be used.
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart.
Most Excel functions require arguments. In this video, we explain how function arguments and how to use them.
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 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'll plot American generations in a chart with floating bars. This seems like a simple problem, but a solution takes a little creative thinking.