It will do this automatically in Excel 2003 as long as formulas appear ion 3
of the last 5 rows so you only have to do this manually for 4 rows, when you
enter numbers in the 5th row in C and D E will automatically add the result
as a formula. For this to work you need to make sure
"Extend list formats and formulas" is checked under toolsoptionsedit

Of course you can change this formula

=C2*D2


to



=IF(COUNT(C2:D2),C2*D2,"")


and copy down the formula a couple of thousands of rows but I would go for
the first option



--
Regards,

Peo Sjoblom









"Chuck" wrote in message
...
I have limited knowledge of Excel but I have a simple question.

How do I apply a formula to an entire column? I want to enter a number
into
columns C and D and have it automatically multiply the numbers and insert
it
into column E. I figured out how to insert a formula into column E that
will
multiply D by E but I have to specify the exact row number each time I
enter
the formula. I might as well do the math myself as re-write the formula
on
each line in column E. How do I get Excel to automatically complete
column E
when I enter the numbers into columns C and D?

(this is hard to describe...I hope it's easier done than said)