Type your formula in E1 then double-click on the fill handle(black square at
bottom right of E1)

Formula will be copied down as far as you have data in column D

You could also left-click on the fill handle of E1 and drag/copy down the
column.

There are other methods but this should get you moving.


Gord Dibben MS Excel MVP

On Tue, 2 Jan 2007 11:18:04 -0800, junkgrrl
wrote:

is there a way i can do it with one formula and not have to type in c1-d1,
c2-d2, etcc...i have about 100 rows

"Dave F" wrote:

=D1-C1 and fill down as necessary.

Dave
--
Brevity is the soul of wit.


"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...