Tom, Just copy the formula to the other cells in the column. Enter the formula in the first row of your calculations. Then highlight the cells that you want to contain the formula, starting with the one that has the formula. Then press control-D and the formula will get copied and adjusted automatically for the row change. Hope this is what you were asking. -----Original Message----- Need to multiply one column by another and show product in the next column. Know the formula for one row (=B2*C2) but can't figure out how to multiply each row in column B by each row in column. For now I am entering the formula in each row but there has to be an easier way. The NOSPIN Group has added a new feature on our website, web based bulletinboard for questions and answers: Visit our sister website at http://nospin.com