similar formula copy

**stokie21** · 01-11-2008, 06:09 AM

is there an auto way of of using a similar formula

i have the whole of row F going down to line 300 a formula which is similar.

i want the first 300 lines of the f box to be

f1 = e1 * d1
f2 = e2 * d2
f3 = e3 * d3
f4 = e4 * d4

and so on all the way to box 300, is there a quick way of the computer doing this or do i have to enter it all 1 by 1 300 times !

i then have row h and row k to do so i will have 900 boxes to do 1 at a time so it kind of taking ages.

any help will be great

many thanks

**davesexcel** · 01-11-2008, 07:28 AM

Originally Posted by stokie21

is there an auto way of of using a similar formula

i have the whole of row F going down to line 300 a formula which is similar.

i want the first 300 lines of the f box to be

f1 = e1 * d1
f2 = e2 * d2
f3 = e3 * d3
f4 = e4 * d4

and so on all the way to box 300, is there a quick way of the computer doing this or do i have to enter it all 1 by 1 300 times !

i then have row h and row k to do so i will have 900 boxes to do 1 at a time so it kind of taking ages.

any help will be great

many thanks

Select the entire range you want the formula, then in the formula box enter =e1*d1
then press the Ctrl and Enter keys