Formatt cell

  • Thread starter Thread starter bob b
  • Start date Start date
B

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.
 
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
 
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.
 
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)
 
Thanks for that help too.
Roger Govier said:
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)
Click to expand...
 
Back
Top