Quick, clean, and to the point

Extend selection by one cell up

Windows shortcut 
Mac shortcut 

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

I think your website is great! It has helped me so much in learning to how to do things in Excel, please keep up the excellent work. -Stuart
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