Exceljet

Quick, clean, and to the point

Copy formula from cell above

Windows shortcut 
Ctrl'
Mac shortcut 
'

This shortcut copies the formula in the cell above to the active (current) current cell and leaves the cell in edit mode. This is a convenient way to make an exact copy of a formula - no cell references are changed.

Related videos

Tip: 30+ Excel Shortcuts in 12 minutes
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
Tip: How to make an exact copy of a formula
Normally, when you copy a formula in Excel, relative cell references automatically change. But sometimes, you want to make an exact copy of a formula, and you don't want the references to change. Watch the short video below to see a few ways you can handle this.
I don't think you understand how much your training has changed my life in terms of work efficiency and effectiveness not to mention minimizing my stress, anxiety and enabling me to shine in front of employers. -Veronika
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course