Excel 2003 - Dragging a formula

[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

 

[Guest]

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

 

[Norman Harker]

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.

 

[seanh49]

Thanks ~× and Norman for your timely responses. It worked perfectly.
-Sea

 

[icestationzbra]

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.