I am not able to extend formulas to successive rows

[Guest]

I am using Office 2003. I am not able to extend formulas to successive rows
in my spreadsheet. When I enter a formula into a cell, the correct answer
will appear in that cell but when I try to highlight that cell and 'control
d' to successive cells only the entry from the original cell appears. (like a
normal repeat) I can't figure out why.

 

[David F Cox]

If you click on the bottom right of the cell and drag across, does that
work?

 

[Gord Dibben]

Tools>Options>Calculation.

Checkmark in "Automatic"


Gord Dibben MS Excel MVP

 

[Guest]

It worked, thanks

 

[Guest]

Your suggestion along with with Mr. Dibben's worked. Thanks