Skill of dragging the little cross

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top