using a formula for a column or range

L

lks1

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.
 
P

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
 
L

lks1

Thank You very muchh

Peo Sjoblom said:
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
Click to expand...
 
Top