hkgal
asked on
Excel fail to pull down formula
I have a excel file and setting some formula in it.
However, when i try to pull down the formula e.g. = A2, by put the mouse at right bottom of cell ( "+"). It fails to pull down the correct formula (should be =A3, =A4, etc...) and only return me with all =A2
what I see:
B column
=A2
=A2
=A2
what I want:
=A2
=A3
=A4
but if I put the cursor in the cell (e.g. in cell with formula =A3) and press "Enter", the value returns back to normal
How can explain this? memory problem or what?
However, when i try to pull down the formula e.g. = A2, by put the mouse at right bottom of cell ( "+"). It fails to pull down the correct formula (should be =A3, =A4, etc...) and only return me with all =A2
what I see:
B column
=A2
=A2
=A2
what I want:
=A2
=A3
=A4
but if I put the cursor in the cell (e.g. in cell with formula =A3) and press "Enter", the value returns back to normal
How can explain this? memory problem or what?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hkgal - Thanks for the points - Patrick