Move to bottom edge of data region
Windows shortcut
Ctrl↓
Mac shortcut
⌃↓
If the active cell is empty, Excel will stop on the first non-empty cell below the active cell. If the active cell is non-empty, Excel will stop on the last non-empty cell below 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 create a stacked column chart. In a stacked column chart, data series are displayed as vertical columns, stacked one on top of the other.
In this video, we'll look at how to update data in a pivot chart. Like pivot tables, pivot charts require a refresh.
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. Much faster than scrolling.
