Copy Formula from Cell Above in Excel
The Copy Formula from Cell Above shortcut copies the formula from the cell directly above the active cell. It is extremely useful when working with rows of data or tables that use formulas.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + D | Cmd + D |
What Does This Shortcut Do?
Pressing this shortcut copies the formula from the cell above into the active cell, adjusting any relative references automatically. It does not affect the value of the original cell above.
How to Use the Shortcut
- Select the cell where you want to copy the formula
- Press Ctrl + D (Windows) or Cmd + D (Mac)
- The formula from the cell directly above will be copied into the active cell
Tips & Best Practices
- Works best in Excel tables or structured rows
- Ensure the formula in the cell above uses relative references correctly
- Can be used multiple times to fill an entire column quickly
FAQ
- Q: Will this copy values as well?
- No, it copies formulas, not the calculated values directly.
- Q: Can I use this in merged cells?
- No, this shortcut does not work correctly on merged cells.