M
mrwawa
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
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