hi xld,
thanks a million.
i never knew that such an option existed.
i unchecked the option and the formula stopped at the cell to where it was dragged.
thanks once again for this very valuable information.
in A1 i enter 6, in A2 i enter 7, in A3 i enter 8, in A4 i enter 5
in B1 i enter 2, in B2 i enter 2, in B3 i enter 3, in B4 i enter 4
in C1 i enter the formula, =A1+B1
i copy the formula down by dragging from C1 to C4.
then i enter 10 in A5, and 11 in B5.
C5 automatically shows A5+B5=21...