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