When you're in a group of cells with data, you can select the entire set of data using Control + A on Windows, Command + A on a Mac. To get out of this mode, just press the Escape key or perform an action. This lets you make multiple selections without holding down a key. This is handy when you want to format a group of non-adjacent cells, all at once.Īs an alternative to control-clicking, you can lock the 'extend selection mode' using Shift + F8 on Windows, Fn Shift F8 on the Mac These selections do not need to be next to one another.
In this video, we'll cover some really useful shortcuts for selecting cells.įirst, as you know, you can click any cell in a worksheet to select it, and, of course, you can click and drag to select multiple cells.īy adding the Control key in windows, or the Command key on a Mac, you can make more than one selection.
