1
F2Verify the source formula or value
Confirm the top cell is correct before copying it down.
Ctrl+DFill DownFormula Copy
Copy Formulas Downward Instantly with Ctrl+D
If you're still dragging to extend formulas down a column, switching to Ctrl+D will noticeably speed up your work.
Shortcuts you will master in this article
Ctrl + D / Ctrl + Shift + ↓ / F2
Dragging to Extend Formulas Is Slow and Error-Prone
The fill handle works, but the longer the range, the more likely you are to miss cells or grab the wrong endpoint. With Ctrl+D, you select the range first and fill in one keystroke.
Especially for pushing the same formula or fixed formatting down a column, the keyboard approach is simply more reliable.
How to Use Ctrl+D in Practice
The key is to include the source cell in your selection.
2
Ctrl + Shift + ↓Select the full range to fill
Grab the source cell and everything below it in one move.
3
Ctrl + DFill down in one shot
The topmost cell in the selection is used as the source for all cells below.
4
Ctrl + `Verify formulas in formula view
After a bulk formula copy, toggle formula view to spot any reference drift.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
When Ctrl+D Works Best
It's especially effective in summary tables where the same calculation needs to go in every adjacent row.
Useful when you also want to copy formatting consistently downward.
If your table has blank rows, check the structure before selecting to avoid filling further than intended.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + D | Fill Down |
Ctrl + Shift + Up | Select to Edge of Data |
F2 | Edit Cell |
Ctrl + ` | Toggle Formula View |
Frequently Asked Questions
Q. Does Ctrl+D work for values and formatting too, not just formulas?
A. Yes. It copies whatever is in the top cell — values, formatting, or formulas — down through the selection.
Q. What's the difference from AutoFill?
A. Ctrl+D reliably copies the same content into every selected cell. AutoFill is better for patterns, sequences, or predictive completion.
Q. What happens if I don't include the source cell in my selection?
A. The reference point shifts and you won't get the result you intended. Always start your selection from the cell you want to copy.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →