Quick, clean, and to the point

Extend selection by one cell down

Windows shortcut 
Mac shortcut 

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

Related videos

Tip: 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.
Thanks so much for Excel tips. I love your lessons. It is easy to follow and each lesson is not too long. - Won
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course