×
英语
很抱歉。本文没有你的语言版本。

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

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×