Thanks for that help too.
"Roger Govier" wrote in message
...
Hi Bob

In addition to Barb's correct answer, you could just set up your column
headers and your first formula
=C3*D3
Then click on the Insert Tab of the ribbon, and choose Table. A dialogue
box will appear, showing the range of your table and My table has headers
will be selected. Click OK.
Now as you add new rows, the table will "grow" automatically and the
formula will be automatically inserted in column E (and any other cells
that have formulae)

--
Regards

Roger Govier


"bob b" wrote in message
...
In Excel 2007 I am trying to select an entire column to do the same thing
for each line.



Column c is hours worked, column d is pay per hour and I want to have
column e be the total $ for that day.



I don't want to add the formula =product(c3:d3) and so on each time to
column e.



How do I make column do this atomically each line?



Thanks in advance. Bob.