COPY and PASTE a FORMULA in Excel

Image of spanners to represent tools
  1. Right-click the cell to copy from
  2. Select ‘Copy’ from the pop-up menu
  3. Right-click in the cell to paste in
  4. Select the ‘Paste as Formula’ icon
  5. The formula will be pasted, and any relative cell references updated to the new location.