Excel fill down shortcut: Ctrl + D
Copy the top cell into all the selected cells below it.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
What it does
Ctrl + D copies the content and format of the top cell of your selection into all the other selected cells below it. It copies formulas too and adjusts the cell references, just like dragging the fill handle. Ctrl + R does the same to the right.
When to use it
Use it to repeat a value, a status or a formula down a column. Select the filled cell and the empty ones below it, press Ctrl + D, and you are done, without dragging the small square.
How to do it
- Type a value, or a formula, in the top cell.
- Select that cell and the empty cells below it (Shift + Down arrow).
- Press Ctrl + D (on a Mac: Command + D). Press Ctrl + R to fill to the right.
A quick example
In the stock list, type 25 in B2, select B2 to B6 with Shift + Down arrow, and press Ctrl + D. All five cells show 25. With a formula in the top cell, each row gets its own version of the formula.
Ctrl + D, Ctrl + R and the fill handle
Ctrl + D fills down and Ctrl + R fills right. The fill handle, the small square in the corner of the cell, does the same by dragging, and it can also continue a series such as 1, 2, 3 or Monday, Tuesday. Ctrl + D only copies the top cell, it does not create a series.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar. In a browser Ctrl + D can bookmark the page, so click into the sheet before you press it.
- Cells below were overwritten: Ctrl + D replaces what is in the selected cells. Press Ctrl + Z and select only empty cells.
- You wanted 1, 2, 3 and got 1, 1, 1: use the fill handle, or Fill, Series, for a series.
- On a Mac use Command + D.
- The letter keys are the English ones. In some language versions of Excel the letters differ. If the keys do nothing in yours, use the matching button on the ribbon instead.
Quick answers
What is the shortcut to fill down in Excel?
Select the top cell and the cells below it, then press Ctrl + D. On a Mac use Command + D.
How do I fill to the right?
Select the cell and the cells to its right, then press Ctrl + R.
Does Ctrl + D copy formulas?
Yes. It copies the formula and adjusts the references for each row, as if you had dragged the fill handle.

