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 find all matches at once in Excel
In this video we show you how to find all matches at the same time.
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 format font and font size in Excel
In this video we show you how to apply fonts and control font size.
How to join cell values with CONCATENATE
In this video we'll look at how to use the CONCATENATE function, an alternative to using the ampersand (&) character to join values in a formula.
How to chart sunrise and sunset
In this video, we'll look at how to plot average daylight hours per month in a chart, using sunrise and sunset data.

Download 200+ Excel Shortcuts

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