Copy and Paste a Formula from One Cell into Another
Select the cell that contains the formula you want.
Press CTRL+C.
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.
Press CTRL+V
Press ENTER to accept the formula.