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
A handy shortcut for hopping around large lists or tables. Much faster than scrolling.
A really fast way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
A cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. Excel does all the hard work for you.
In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick, messy chart is a great way to "sanity check" unfamiliar data. A chart can show you patterns and outliers almost instantly. It can even show when data has been faked. Best of all, you get all of this with almost no effort.
