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 update data in a pivot chart. Like pivot tables, pivot charts require a refresh.
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 make a stacked area chart. Stacked area charts are useful to show changes in a part-to-whole relationship over time.
A tip for moving through a large list. Much faster than scrolling.
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.
