Copy the formula from the cell above
Master this Excel shortcut with our comprehensive guide
Cut, Copy, and Paste Shortcuts in Excel
Ctrl + ‘
⌘ + Shift + ‘
How to Use This Shortcut
Keyboard Shortcut
Ctrl + ‘
Instructions
1. Select the cell below
2. Press Ctrl + ‘
3. The formula from the cell above is copied
2. Press Ctrl + ‘
3. The formula from the cell above is copied
Keyboard Shortcut
⌘ + Shift + ‘
Instructions
1. Go to the cell below the formula
2. Press Command + Shift + ‘
3. Formula from the above cell is copied
2. Press Command + Shift + ‘
3. Formula from the above cell is copied
💡 Pro Tip: Saves time when repeating the same formula across multiple rows.
Quick Actions
More Cut, Copy, and Paste Shortcuts in Excel
Ctrl + C
Ctrl + X
Ctrl + V