![]() Let me show you how working with the active cell can be helpful. On a mac, the shortcut is Control + Option plus the right or left arrow. When you have multiple selections on the worksheet, you can the move the active cell to each selection using Control + Alt + and the right or left arrow in windows. ![]() With multiple cells selected, you can always reduce your selection to the active cell only by pressing Shift + Backspace on Windows, Shift + Delete on a Mac. This is a handy shortcut, as we'll see in a minute. You can rotate the active cell through the 4 corners of your selection using Control + period. And to move the active cell left, use shift + tab. To move the active cell down, use the enter key, and to move it up, use shift + enter. When you have multiple cells selected, you can move the active cell anywhere you like without affecting the selection itself. ![]() However, when you make a new selection, the active cell will update. If you extend this selection in any direction, you'll see that the active cell doesn't change. When the active cell is off screen, you can scroll it into view, without actually changing the active cell, using Control + backspace on Windows, Command + Delete on a mac. In this video, we'll cover shortcuts for working with the active cell.Īs I mentioned earlier, every worksheet has an "active cell", which you can see displayed in the name box.
0 Comments
Leave a Reply. |