Select the cell that contains the formula that you want to move.

On the Home tab, in the Clipboard group, click Cut.

Do one of the following:

  • To paste the formula and any formatting, on the Home tab, in the Clipboard group, click Paste.
  • To paste the formula only, on the Home tab, in the Clipboard group, click Paste, click Paste Special, and then click Formulas.

You can also move formulas by dragging the border of the selected cell to the upper-left cell of the paste area. Any existing data will be  replaced.