Move a formula

Moving formulas is very much like moving data in cells. The one thing to watch for is that the cell references used in the formula are still what you want after you move.

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

  2. Click Home > Cut (or press Ctrl + X).

Cut command in the Clipboard group

  1. Select the cell you want the formula to be in, and then click Paste (or press Ctrl + V).

Paste command in the Clipboard group

  1. Verify that the cell references are still what you want.

    Tip:  You can also right-click the cells to cut and paste the formula.
    Right-click to see the Copy, Cut, and Paste commands

Tip:  You can also copy and paste a formula to another cell or worksheet.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!