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.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: How to chart generations with floating bars
How to chart generations with floating bars
In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special feature of data labels. A nice example of what can be done with Excel's charting engine.