Problem with autofill
 

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!

Problem with autofill
 

I wonder if your calculation is set to MANUAL. Check Tools - Options -
Calculation and change to Automatic.
--
HTH,
Barb Reinhardt



" wrote:

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!

Problem with autofill
 

On Sep 7, 10:48 pm, Barb Reinhardt
wrote:
I wonder if your calculation is set to MANUAL. Check Tools - Options -
Calculation and change to Automatic.
--
HTH,
Barb Reinhardt

Thanks- that did it...