Copy the formula from the formula bar.

Select cell A3
Highlight the formula in the formula bar
Right clickCopy
Hit Esc (escape)
Select the cell where you want the formula copied to
Right clickPaste

--
Biff
Microsoft Excel MVP


"ant1983" wrote in message
...
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?