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 show you how to select whole rows and columns.
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 use the COUNT function to count cells that contain numeric data.
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'll look at some tips and tricks for using the SUM function; one of the most widely used functions in Excel.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
