View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?