Prob an easy one: How do i copy a formula EXACTLY as it is
Use absolute referencing
=$A$1+$A$2
Below are the different reference styles.
A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.
If this post helps click Yes
---------------
Jacob Skaria
"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?
|