Drag Formula copies values instead

G

Guest

Hi,
When I drag formula down, it will copy the value of the cell, even through
the values of the formula get updated.
What I mean, if I were to drag the formula in 1A down to 3A, it would result
in:
Comumn A Column B Column C
Row 1 3 (formula is 1B+1C) 1 2
Row 2 3 (formula is 2B+2C) 3 4
Row 3 3 (formula is 3B+3C) 5 6

So the formulas are correct, yet the valus are wrong. It will work if I
clear the contents and retype them, or if I right click on the first cell,
drag and click "Fill Formats". This just started yesterday, on two different
worksheets (no viruses). Anyone???
 
G

Guest

Is your Calculation option set to Manual? If so, the formulas copied down
would appear as you described until the worksheet was recalculated.

Hope this helps,

Hutch
 
G

Guest

Yes, that was it... I had mistakenly posted twice about the same question..
thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top