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.
Related videos
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.