1
↓ (move to cell below)Navigate to where the formula should goMove 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 aboveInherits the formula from directly above as-is.
3
F2Edit part of the formula if neededGood flow for making minor tweaks after copying.
4
Ctrl + DSwitch to Fill Down for a wider rangeUsing 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 from Cell Above |
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 switch between difficulty, category, and review practice for faster retention.