What is the shortcut for Copy Formula?
Windows: Ctrl+'. Mac: Ctrl+'.
📊Excel Shortcut
Copy Formula
Detailed guide to use "Copy Formula" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl
'
Windows shortcut: Ctrl+'
Mac
Ctrl
'
Mac shortcut: Ctrl+'
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
Auto-playing example
Active: D2Selection: D2Sheet: Sheet1Step 1/3
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
D2
Formula Bar
fx=B2-C2◢ | A | B | C | D |
|---|---|---|---|---|
| 1 | Month | Sales | Cost | Margin |
| 2 | Jan | 2000 | 1400 | 600 |
| 3 | Feb | 1850 | 1300 | |
| 4 | Mar | 2100 | 1500 | 600 |
Sheet1
Ready100%
Basic Info
- Category
- Editing
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Copy Formula is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Copy the formula from the cell above.
Related Shortcuts
More In This Category
FAQ
How do I use Copy Formula?
Use it after selecting the target cell or range to speed up edits and fixes.
What shortcuts should I practice after Copy Formula?
Practice copy, line break in cell, and reference toggle next and you can move through common Excel work much faster.
Where can I practice Copy Formula?
Use the page button to start a focused drill right away. If you switch to full practice, you can review copy, line break in cell, and reference toggle in the same flow.
What is the action preview for Copy Formula?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.