- Right-click the cell to copy from
- Select ‘Copy’ from the pop-up menu
- Right-click in the cell to paste in
- Select the ‘Paste as Formula’ icon
- The formula will be pasted, and any relative cell references updated to the new location.
COPY and PASTE a FORMULA in Excel
![Image of spanners to represent tools](https://excelquick.com/wp-content/uploads/2018/07/excel-quick-help-tools_128.png)