Copy Value from Cell Above in Excel
The Copy Value from Cell Above shortcut allows you to quickly copy only the value (not the formula) from the cell directly above into the active cell. This is useful when you want to replicate data without copying formulas.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + D | Cmd + Shift + D |
What Does This Shortcut Do?
Pressing this shortcut copies only the value from the cell above into the active cell. Any formulas in the source cell are ignored.
How to Use the Shortcut
- Select the cell where you want to copy the value
- Press Ctrl + Shift + D (Windows) or Cmd + Shift + D (Mac)
- The value from the cell directly above will appear in the active cell
Tips & Best Practices
- Useful when you need to fill down values without affecting formulas
- Works well in lists, tables, or repeated data entries
- Combine with Ctrl + D (Copy Formula) for flexible data management
FAQ
- Q: Will this copy formatting?
- No, it copies only the cell value, not formatting.
- Q: Can this be used on merged cells?
- No, shortcut works only on single cells.