I'm not sure I fully understand but have a look at the formula below:-

=A$1+A$2

The $ sign makes it stays the same when dragged down but if it is dragged
right then the column letter changes.

Mike

"tracing precedent by double clicking cel" wrote:

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?