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 control key (⌃) can be used instead of the command 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 that's much faster than scrolling.
In this lesson, we cover shortcuts you can use to navigate worksheets.

Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.