Can you change the function of the fill handle on a cell in Excel

I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell
it says it is adding up the correct cells. When you double click on that
cell then it amends the figure to be correct.

Check to see that your calc mode is set to auto:

<Tools> <Options> <Calculation> tab,
And make sure "Automatic" *is checked*.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"AndreaRaRa" <[email protected]> wrote in message
news:[email protected]...
I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell
it says it is adding up the correct cells. When you double click on that
cell then it amends the figure to be correct.

Have you perhaps turned off auto-calculation? (Tools / Options, on the
Calculation tab). You could either set this to Automatic or, when you need
calcs updated, hit function key F9.

"AndreaRaRa" wrote:

> I have a problem when dragging formulas across. Every cell is holding the
> figure from that of the one i am dragging from but when you look at the cell
> it says it is adding up the correct cells. When you double click on that
> cell then it amends the figure to be correct.

Check to see that your calc mode is set to auto:

<Tools> <Options> <Calculation> tab,
And make sure "Automatic" *is checked*.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"AndreaRaRa" <[email protected]> wrote in message
news:[email protected]...
I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell
it says it is adding up the correct cells. When you double click on that
cell then it amends the figure to be correct.

Have you perhaps turned off auto-calculation? (Tools / Options, on the
Calculation tab). You could either set this to Automatic or, when you need
calcs updated, hit function key F9.

"AndreaRaRa" wrote:

> I have a problem when dragging formulas across. Every cell is holding the
> figure from that of the one i am dragging from but when you look at the cell
> it says it is adding up the correct cells. When you double click on that
> cell then it amends the figure to be correct.