Here is how to MOVE a formula:
Select the cell that contains the formula that you want to move.
You can also move formulas by dragging the border of the selected cell to the upper-left cell of the paste area. This will replace any existing data.
Do one of the following:
To paste the formula and any formatting: In the Clipboard group of the Home tab, click Paste.
To paste the formula only: In the Clipboard group of the Home tab, click Paste, click Paste Special, and then click Formulas.