Monday, February 4, 2019

Move a formula

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

No comments:

Post a Comment