Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Formula copies values instead
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??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Formula copies values instead
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 "TxVics" wrote: 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??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag Formula copies values instead
Yes, that was it... I had mistakenly posted twice about the same question..
thank you! "Tom Hutchins" wrote: 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 "TxVics" wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automate replace values in formula | Excel Discussion (Misc queries) | |||
I have a formula that copies itself when adjacent cells are filled in. How? | Excel Discussion (Misc queries) | |||
SUM formula - using variable values | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) |