ShortcutdrillExcel shortcuts / editing / Fill down
Fill down in Excel: Ctrl+D (Mac: Cmd+D)
| Windows | Ctrl+D |
|---|---|
| Mac | Cmd+D |
| Group | editing |
Drill: Copy a formula down. Pro drill. Twenty-five drills are free.
What it does and when to use it
Select the cell with the formula and the cells below it, then Ctrl+D copies the formula down with references adjusted. With one cell selected it copies the cell above.
The common mistake
Selecting only the empty cells. The selection has to start at the cell holding the formula.
Related shortcuts
- Undo Ctrl+Z
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- Insert a row Shift+Space, Ctrl+Shift+=
- The printable cheat sheet
Questions
How do I fill a formula down 10,000 rows?
Select the formula cell, Ctrl+Shift+Down in a neighboring full column to find the extent, then Ctrl+D. Or double-click the fill handle, which stops at the first gap next to it.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill