Nick, put you formula in C1, select C1, click on the black little square on
the bottom right, click the mouse and drag down as far as needed
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"n21" wrote in message
...
I am looking to multply one column by another in each row for a long set of
data.
Example:
A B C

5 2 10
3 4 12
2 3 6

Instead of having to enter a product formula in each cell of column c, is
there a way to do this for every row in the data set in a function?

Thanks for the help,

Nick