Move to top edge of data region
Windows shortcut
Ctrl↑
Mac shortcut
⌃↑
If the active cell is empty, Excel will stop on the first non-empty cell above the active cell. If the active cell is non-empty, Excel will stop on the last non-empty cell above the active cell.
On a Mac, the command key (⌘) can be used instead of the control key.
Related videos
The videos below demonstrate this shortcut.
In this video, we'll look at how to use a "throwaway" chart to explore data. This is an easy way to quickly size up data.
We'll show you a cool way to delete rows that are missing values in one step, even when your list contains hundreds or thousands of rows.
A tip for moving through a large list. Much faster than scrolling.
In this video, we'll use MATCH to find the position of an item in a table, and the INDEX function to retrieve the value at that position in a two-way lookup.
