using a formula for a column or range

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Guest]

Thank You very muchh

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