1
↓ (move to cell below)Navigate to where the formula should go
Move to the cell directly below the one containing the source formula.
copy formulaCtrl+'input efficiency
How to Copy a Formula As-Is with Ctrl+'
When you need to put the same formula one row down, Ctrl+' can be quicker than Ctrl+D.
Shortcuts you will master in this article
Ctrl + ' / F2 / Ctrl + D
There is no need to use a heavy operation for a small formula copy
Fill Down is convenient, but it can feel like overkill for inheriting just one cell's formula. Ctrl+' is designed for the 'bring the formula from right above' use case.
Having shortcuts at different granularity levels pays off most in tasks that involve fine-grained work.
When to reach for Ctrl+'
Think of it as a small, fast copy and it becomes easy to fit into your workflow.
2
Ctrl + 'Copy the formula from the cell above
Inherits the formula from directly above as-is.
3
F2Edit part of the formula if needed
Good flow for making minor tweaks after copying.
4
Ctrl + DSwitch to Fill Down for a wider range
Using the right tool for the job reduces waste.
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.
Where Ctrl+' is the right fit
Best for one-off additions or a single inserted row mid-table.
Useful when you want the same logic as the cell above but selecting a range is unnecessary.
A helpful mental model: Ctrl+D for bulk, Ctrl+' for single — role separation makes both easier to remember.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + ' | Copy Formula |
F2 | Edit Cell |
Ctrl + D | Fill Down |
Frequently Asked Questions
Q. Does the value come along with it?
A. Think of it primarily as a formula-inheriting operation for clarity.
Q. Which should beginners learn first, Ctrl+D or Ctrl+'?
A. Ctrl+D has higher frequency, but Ctrl+' is useful for single-cell cases.
Q. Does it work the same on Mac?
A. There may be environment differences — verifying key assignments on your actual machine is recommended.
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スキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →