Copy and paste a formula from one cell into another cell
- Select the cell that contains the formula you want.
- On the Edit menu, click Copy.
To replace the entire formula, select the cell whose formula you want to replace.
To paste the formula into an existing formula, double-click the cell, and then click an insertion point where you want to paste the formula.
- On the Edit menu, click Paste.
- Press ENTER to accept the formula.