Formatt cell
 

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.

Formatt cell
 

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" wrote:

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.

Formatt cell
 

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.

"Barb Reinhardt" wrote in message
...
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" wrote:

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.

Formatt cell
 

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.

Formatt cell
 

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.