Simple Cut and Paste Problem

[Lance Gray]

I am in a new worksheet, and am creating a very simple
formula "=D3/C3". The result shows $5.20 in cell E3.
When I cut and paste (or drag) to repeat this function all
the way down my worksheet, Excel is putting in $5.20 in
each cell. Can anyone tell me what I need to do to fix
this?
Thanks,
Lance

 

[Rita Palazzi]

Hold down the CTRL key as you drag the formula down the column.

 

[Max]

One guess ..

Calculation mode could have "inadvertently"
been set to "Manual" ?

Try pressing F9. Do the formulas now compute properly ?

To change / check calc mode settings:

 

[Guest]

Yes, that worked perfectly, thank you. In the calculation
tab, it was checked for "Manual" calculation. I have no
idea how that could have changed, but I will keep an eye
on it.
Again, thank you!
Lance

 

[Max]

Glad it worked, Lance !

As for ..

.. tab, it was checked for "Manual" calculation. I have no
idea how that could have changed, ...

The calculation mode of each Excel session
is dictated by the calc mode of the first book opened
within the session.

For example, if the first book's calc mode is "Manual",
then the mode for all subsequent books opened in the same
Excel session (i.e. until / unless Excel is exited) will
be "Manual", irregardless of their earlier saved modes.