copying cell formula newbie.
 

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.

copying cell formula newbie.
 

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

wrote in message
...
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.