Move to right edge of data region
Windows shortcut
Ctrl→
Mac shortcut
⌃→
If the active cell is empty, Excel will stop on the first non-empty cell to the right. If the active cell is non-empty, Excel will stop on the last non-empty cell to the right.
On a Mac, the command key (⌘) can be used instead of the control key.
Related videos
The videos below demonstrate this shortcut.
Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to base one pivot table on another.
A tip for moving through a large list. Much faster than scrolling.
In this lesson, we cover shortcuts you can use to navigate worksheets.
