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.
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.
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 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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
