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.

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


"jrich15322" wrote in message
...
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.

ToolsOptionsCalculation.

Checkmark in "Automatic"


Gord Dibben MS Excel MVP

On Sat, 14 Oct 2006 06:11:02 -0700, jrich15322
wrote:

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.

It worked, thanks

"jrich15322" wrote:

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.

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

"David F Cox" wrote:

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


"jrich15322" wrote in message
...
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.