Exceljet

Quick, clean, and to the point

Extend selection by one cell down

Windows shortcut 
Shift↓
Mac shortcut 
⇧↓

If multiple cells are selected, Excel will extend the entire bottom edge of the current selection.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to fill in missing data part 2
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions.
Shortcuts for selecting cells in Excel
In this video we show you some of Excel's shortcuts for selecting cells.
Shortcuts for extending selections
In this lesson, we cover shortcuts you can use to extend selections.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.