Moving cell refs

[bobbych]

I want to move formula to a new cell but keep origionall Cell Referencing. At the mo if i move a cell formula 2 cells right the formula ref moves 2 right to. I hope that makes sense.

thanks in advance

[mikerickson]

Are you using absolute addressing?

Relative addressing (e.g. =A1) will act as you describe.
Formulas that use absolute addressing (e.g. =$A$1) will not change.
Mixing them in the same formula is possible e.g. =$A$1 + B1, as are mixed forms.
$A1 will change to $A2, $A3 when dragged down, but will always look to column A when dragged right.

[bobbych]

Nice one.
Sorted cheers