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 plot average daylight hours per month in a chart, using sunrise and sunset data.
In this video, we show you how to apply bold, italic, and underlining styles to text.
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 show you how to apply fonts and control font size.
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.
