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 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |