Hi all,

I'm using Excel 2003 to generate a sheet like following.
A1 is the only "price", which I could change the value.
From B1 to B200, perhaps, the cells show the quantities.
Cells from C1 to C200 show the costs, which is always Cost multiplied by
A1(Price).
So I type a formula in C1, which is B1*A1. This one is well working. Of
course, I don't want to type all the 200 cells one by one. So I drag the
little cross at the right bottom corner of C1 to make it expand to C200. I
expect that all the value should become Bn*A1. However, all the values become
Bn*An, instead of Bn*A1.
My question is how to fix the A1 in this situation?

fish