Enter =A1*B1 in C1

Double-click on the fill handle of C1


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 23:24:01 -0800, Ryan
wrote:

Suppose column A has "quantity" values, column B has "amount" values, and I
want column C to be their products. I have 950 rows of this and I don't want
to enter 950 formulas into each row of C.

In other words I need Cn=An*Bn where n=row number.

Thanks