View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tracing precedent by double clicking cel[_2_] tracing precedent by double clicking cel[_2_] is offline
external usenet poster
 
Posts: 2
Default Formula on the right

A B C D
E

1 25 30 25*30 100*100
10*10
2 100 100 100*100
3 10 10 10*10

WHEN THE FORMULA IS DRAGGED FROM C1 TO DOWN SAME FORMULA IN COPIED HOWEVER
WHEN THE C1 FORMULA IS DRAGGED ONTO THE RIGHT THIS DOES NOT HAPPEN, WHY AND
HOW?