Prob an easy one: How do i copy a formula EXACTLY as it is
You could re-write the formula as:
=$A$1 + $A$2
Then when you copy it to another cell it will not change the cell
references.
Hope this helps.
Pete
On Nov 26, 9:27*am, ant1983 wrote:
Scenario:
A1 + A2 = A3
so in A3 i have "=A1+A2"
So if i want to copy that formula in lets say B3 then it would adapt the
reference so it would ready "=B1+B2"
I dont want that - how can i keep that original refernces wherever i copy
the formula?
|