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.
-
Select the cell that contains the formula you want to move.
-
Click Home > Cut (or press Ctrl + X).
-
Select the cell you want the formula to be in, and then click Paste (or press Ctrl + V).
-
Verify that the cell references are still what you want.
Tip: You can also right-click the cells to cut and paste the formula.
Tip: You can also copy and paste a formula to another cell or worksheet.
No comments:
Post a Comment