Copy the value from above cell
Master this Excel shortcut with our comprehensive guide
Cut, Copy, and Paste Shortcuts in Excel
Ctrl + Shift + ‘
⌘ + Option + ‘
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + ‘
Instructions
1. Select the cell below
2. Press Ctrl + Shift + ‘
3. The value from the cell above is copied (not the formula)
2. Press Ctrl + Shift + ‘
3. The value from the cell above is copied (not the formula)
Keyboard Shortcut
⌘ + Option + ‘
Instructions
1. Go to the cell below
2. Press Command + Option + ‘
3. The value from the above cell is copied
2. Press Command + Option + ‘
3. The value from the above cell is copied
💡 Pro Tip: Great for quickly duplicating static values without formulas.
Quick Actions
More Cut, Copy, and Paste Shortcuts in Excel
Ctrl + C
Ctrl + X
Ctrl + V