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 control key (⌃) can be used instead of the command 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.
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.
A tip for moving through a large list that's much faster than scrolling.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
