"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.

Start with column C in the first row, say C2. Enter the formula that you
want, say:

=A2*B2

Now, put the cursor in C2, and copy it. Several ways to do that; I usually
just press ctrl+C.

Now, enter C3:C950 into the Name Box. In Excel 2003, that is in the upper
left corner under the toolbar. That will effectively select the entire range
of cells. Much easier than trying to select all the cells manually or
dragging C2 down 950 rows by using the handle in the lower right of the cell
C2.

Then paste into the selected range. Several ways to do that; I usually just
press ctrl+V.

If you look at C3 etc, you will see that the relative references A2 and B2
are automagically updated to reflect the current row, e.g. A3 and B3.