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.

See all shortcuts

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 work and how to use them.
How to use table slicer options
Table slicers have a variety of settings. In this video, we'll look at how to configure available options.
How to change the font color in Excel
In this video we show you how to change font color and demonstrate how Excel's live preview can help you select a color.
How to create a multi level axis
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.
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.

Download 200+ Excel Shortcuts

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