Problem with autofill

M

myerburg

Hi-

Previously I was able to make column c= column 1 + column b. When I
selected column 3 and dragged it down it would continue to add the two
columns for each row. Now when I drag down it only copies the
selected cell.

Has anyone had this problem or know of a solution?

Thanks!
 
B

Barb Reinhardt

I wonder if your calculation is set to MANUAL. Check Tools -> Options ->
Calculation and change to Automatic.
 
Top