If you have data in column D, type the formula =D2/C2 in E2.

Double-click on the fill handle of E2 to copy down with cell references
incrementing.


Gord Dibben MS Excel MVP

On Tue, 23 Oct 2007 09:04:04 -0700, Mitch
wrote:

How can I apply a formula to (an) entire column(s), with results applied to
individual rows? For instance, if I want every row to divide column D by C
and enter the result in column E. Do I have to enter the formula for each
and every row using the "=D2/C2" formula in the E2 column, then "=D3/C3" in
the E3 column, etc., one at a time?

I hope I'm being clear!

Thanks