Formatt cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bob b - 25 Apr 2007 00:10 GMT

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.

Reply to this Message

Barb Reinhardt - 25 Apr 2007 00:44 GMT

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

> In Excel 2007 I am trying to select an entire column to do the same thing
> for each line.
[quoted text clipped - 8 lines]
>
> Thanks in advance. Bob.

Reply to this Message

bob b - 25 Apr 2007 01:02 GMT

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.

> I'll answer this for 2003.
>
[quoted text clipped - 19 lines]
>>
>> Thanks in advance. Bob.

Reply to this Message

Roger Govier - 25 Apr 2007 10:57 GMT

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)

Signature

Regards

Roger Govier

> In Excel 2007 I am trying to select an entire column to do the same
> thing for each line.
[quoted text clipped - 8 lines]
>
> Thanks in advance. Bob.

Reply to this Message

bob b - 25 Apr 2007 15:55 GMT

Thanks for that help too.

> Hi Bob
>
[quoted text clipped - 20 lines]
>>
>> Thanks in advance. Bob.

Reply to this Message