Thread: Prob an easy one: How do i copy a formula EXACTLY as it is
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ant1983 ant1983 is offline
external usenet poster
  
Posts: 12
Default Prob an easy one: How do i copy a formula EXACTLY as it is
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?
Reply With QuoteReply With Quote