Excel fail to pull down formula
Posted on 2011-02-23
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:
what I want:
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?