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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.