Forum Discussion
Copying without refreshing references
Hello, I'd like to copy a formula in a cell to another cell without refreshing references, I mean, exactly the same formula en other location. I know that i can move the formula with "CtrlX" but...
Let's say you have a formula such as
=SUM(A1:A4)
If you copy the cell with the formula and paste it elsewhere, the range in the formula will change. You can prevent this by making the range reference absolute:
=SUM($A$1:$A$4)
The range will then remain the same when you copy/paste the cell with the formula.
Another option:
- Select the cell with the formula.
- Press F2 to edit the cell, or click in the formula bar.
- Select the entire formula (Ctrl+A) and copy it (Ctrl+C).
- Press Esc to stop editing the cell.
- Select the target cell and paste (Ctrl+V).