- 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.
Next Post: COMPARE more than two values in Excel