Skill of dragging the little cross

F

fish

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
 
S

scottymelloty

highlight the bit of the forumla you want to stay the same in every cel
and press F4 on the top of your keyboard, this should put a dollar sig
around it , press enter then do same as before by dragging it dow
 
A

AMC

click in the formula bar where it says A1 and press F4 so it so Read
=B1*$A$1
then drag it into the res of your cells.
 
Top