Excel: move formulas - so it'll work
If you want to move individual formulas in Excel, you can use the cut function.
Move Excel formulas without loss
If you move formulas in Excel, the original references to other fields are retained. You can even move the commands between worksheets without losing the references.
- Select the field with the formula you want to move.
- Then select "Edit" and "Cut" at the top of the menu bar. Alternatively, you can also use the key combination [Ctrl] + [X].
- Now click on the field where you want to move your formula and select the "Edit" option again. Then click on "Paste". Alternatively, the key combination [Ctrl] + [V] is sufficient.
- You have now moved the formula without changing the references in your formula.
In another practical tip, we will show you how you can fix lines in Excel.