copying cell formula newbie.

[Guest]

Hi,
I added a formual to a cell, which just multiplies a a different cell by 0.90. Now when I use the mouse to copy
mouse clicking and dragging it to all the other cells below it remembers the first cell amount even though it has
updated the cell number.
It works properly on other spreadsheets without any problem.What am I doing wrong ?
for example
cell a6 = 100 (a1*0.90)
cell b6 = 100 (b1*0.90)
even though a1 and a2 contain different values.

I hope I have explained it well enough for any one to help me.

Thank You.

 

[David Biddulph]

Tools/ Options/ Calculation
Set to Automatic, rather than Manual.