- Select the cell that contains the formula that you want to move.
- On the Home tab, in the Clipboard group, click Cut.
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 is replaced.
- 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.