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.
A tip for moving through a large list that's much faster than scrolling.
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.
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.
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.
