Exceljet

Quick, clean, and to the point

Fill down from cell above

Windows shortcut 
CtrlD
Mac shortcut 
D

This shortcut clones data from the cells above to cells below, without having to copy and paste. To fill down into more than one cell at once, make a selection that includes multiple rows below.

Source and target cells do not need to be next to each other, but you'll need to select the target cell first before the source cell in this case.

Related videos

Tip: 30+ Excel Shortcuts in 12 minutes
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
Tip: Shortcuts to enter data in Excel
Did you know you can use shortcuts to control the direction Excel moves when you press Enter? In this video, learn a boatload of shortcuts for entering data in Excel.
Such a great resource! Really appreciate your help - Carole
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course