Formatt cell

[bob b]

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.

 

[Barb Reinhardt]

I'll answer this for 2003.

Enter your formula.
Select the cell. There should be a little box in the lower RH corner. Drag
it down to the remainder of the cells you want to populate.

HTH,
Barb Reinhardt

 

[bob b]

Thanks, that was too easy! (g)
It was the same in 2007.
I have trouble finding anything in the help files for easy things such as
that.

 

[Roger Govier]

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)

 

[bob b]

Thanks for that help too.

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)