Problem dragging formulas
 

Hi all,

I have a problem dragging formulas when I use Excel, and am wondering
what happened. Previously I was able to add column A and column B in
column C in row one, right click and drag the formula down column C
and it would compute the values from row 1 to n. Now, however, It is
dragging the value in column C row 1, but the formula bar is showing
that the formula is indeed being "dragged". For example, if the sum
of A1 and B1 is 5, then 5 is dragged from C1 to Cn, but when I look in
the formula bar, it displays =A2+B2, =A3+B3 etc, as it should.

Has anyone seen this problem before, and if so how can I fix it?

Thanks,

Wade

Problem dragging formulas
 

calculate or set calculation to automatic

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mrwawa" wrote in message
...
Hi all,

I have a problem dragging formulas when I use Excel, and am wondering
what happened. Previously I was able to add column A and column B in
column C in row one, right click and drag the formula down column C
and it would compute the values from row 1 to n. Now, however, It is
dragging the value in column C row 1, but the formula bar is showing
that the formula is indeed being "dragged". For example, if the sum
of A1 and B1 is 5, then 5 is dragged from C1 to Cn, but when I look in
the formula bar, it displays =A2+B2, =A3+B3 etc, as it should.

Has anyone seen this problem before, and if so how can I fix it?

Thanks,

Wade