Thread: Fixed vlaue in the Fill handle opperation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrusPB BrusPB is offline
external usenet poster
  
Posts: 1
Default Fixed vlaue in the Fill handle opperation
Hi
I have this formula in Cell A3:
sum(A1+A2)

I want to fill handle this cell and have the cell A4 as below:
sum(A1+A3)

As you see, the A1 must be fixed. But this operation makes the A4 as below:
sum(A2+A3) which is not my aim.

Thnx 4 any reply.
Reply With QuoteReply With Quote