We'll cover all these options in upcoming videos.

On Macs without an End key, use Fn + Control + right arrow.Įxcel also contains powerful tools and shortcuts for selecting special groups of cells, including ways to select all formulas, all contacts, all text, blank cells, and so on. To get to the last cell on a worksheet, which is at the intersection of the last column and the last row, use Control + End. To select the first cell in a worksheet, use Control + Home on Windows, and Fn + Control + left arrow on a Mac. These shortcuts work also when multiple cells are selected as. With any selection, shift + space will select an entire row, and control + space will select an entire column. Using this shortcut again will select the entire worksheet. 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 This is how you execute commands on your Mac using the command line. These selections do not need to be next to one another. Your Mac comes with an app called Terminal under Applications > Utilities. Forward Delete (on a portable Mac’s built-in. 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. Open Front Row (if installed) Option + Media Eject () Eject from secondary optical media drive (if one is installed) Fn + Delete.

Select all command in mac