View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Prob an easy one: How do i copy a formula EXACTLY as it is

You need =$A1+$A2, or =$A$1+$A$2 if you also want to be able to copy down
without it changing.

Look in Excel help for the difference between absolute and relative
addressing.
--
David Biddulph

"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?