# 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

The videos below demonstrate this shortcut.

Sometimes you want to reference a worksheet dynamically in a formula, so that it can be changed on the fly. In this video, we'll look at how to create a dynamic reference to a worksheet in a formula.

In this video, we'll look at how to several ways calculate the number of days between dates. To get started, let's first first set up some dates, so we have a visual representation to refer to.

This video shows how to stop Excel from changing cell references when you want an exact copy of a formula in a different cell.