using a formula for a column or range
 

I am trying to do a spreadsheet with this funtion

=A1*D1
and not type this in 900 times ex:
=A1*D1
=A2*D2
=A3*D3
ETC ETC.

i'm sure this is an easy one for someone.

using a formula for a column or range
 

Type A1*D1 into the cell, press enter, select the cell again, move the
cursor to the lower right corner of the cell and click and hold the left
mouse button, then just drag the formula down to wherever you want it to
stop and the formula will change with each row


--
Regards,

Peo Sjoblom



"lks1" wrote in message
...
I am trying to do a spreadsheet with this funtion

=A1*D1
and not type this in 900 times ex:
=A1*D1
=A2*D2
=A3*D3
ETC ETC.

i'm sure this is an easy one for someone.

using a formula for a column or range
 

Thank You very muchh

"Peo Sjoblom" wrote:

Type A1*D1 into the cell, press enter, select the cell again, move the
cursor to the lower right corner of the cell and click and hold the left
mouse button, then just drag the formula down to wherever you want it to
stop and the formula will change with each row


--
Regards,

Peo Sjoblom



"lks1" wrote in message
...
I am trying to do a spreadsheet with this funtion

=A1*D1
and not type this in 900 times ex:
=A1*D1
=A2*D2
=A3*D3
ETC ETC.

i'm sure this is an easy one for someone.