Excel 2003 - Dragging a formula

  • Thread starter Thread starter seanh49
  • Start date Start date
S

seanh49

Example:
A B C
1) 2 5 10(=A1*B1)
2) 9 18(=A1*B2)

I have a spreadsheet that has approx. 1,000 rows. How do I drag this
same formula down for every row? When I try it, this is the results I
get, look at row 3:

A B C
1) 2 5 10(=A1*B1)
2) 9 18(=A1*B2)
3) 4 0(=A3*B3)

Notice that when I drag it that instead of multiplying cell A1*the next
cell in column B it mulitplys the same row in column A and B.

I would appreciate any thoughts.
Thanks in advance,
-Sean
 
what you're looking for is "=$A$1*B1", "=$A$1*B2", etc - just put a dollar sign in front of the A and the 1 and they won't budge
 
Hi Seanh49!

It sounds like you want:
C1:
=$A$1*B1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
just an appendage to what has already been said above.

in the fomula bar, select the celladdress (A1, B2 etc.), and click F4.
it will toggle the $'s.

also, it might be advisable to have a $ for B1 from your example. this
will lock column B and increment on rows from 1 to wherever you drag
it.
 
Back
Top