If you extend this selection in any direction, you’ll see that the active cell doesn’t change.
Only the selection changes.
However, when you make a new selection, the active cell will update.
To move the active cell right, use tab.
And to move the active cell left, use shift + tab.
you might rotate the active cell through the 4 corners of your selection using Control + period.
This is a handy shortcut, as we’ll see in a minute.
On a Mac, the shortcut is Control + Option plus the right or left arrow.
Let me show you how working with the active cell can be helpful.
In this worksheet, we have a set of employee data, which is summarized by this pivot table.
you’ve got the option to see that we have data for 300 employees.
I don’t know whether the new data contains more or fewer employees.
This makes it easy for me to see and delete the extra rows.
