How to copy values in various rows automatically

Me · Mar 4, 2005

I have a worksheet function for a cell.
Now I would like to copy this function for all the rows
in this column. How can it be done?

Like copy A1 to A2 thru' A900

Thank you,
-Me

Earl Kiosterud · Mar 4, 2005

Me,

Select A1. Drag the Fill Handle (lower right corner button) down.

Me · Mar 4, 2005

Earl,

Thank you very much, it works!
-Me

Earl Kiosterud said:
Me,

Select A1. Drag the Fill Handle (lower right corner button) down.

Gord Dibben · Mar 4, 2005

Me

Select A1 then in Name Box to the left of the Formula Bar type in A1:A900 and
hit ENTER key.

Type your formula in A1 and hit CTRL + ENTER.

If formula is already entered in A1, hit F2 then CTRL + ENTER after selecting
the range.

Gord Dibben Excel MVP

Me · Mar 7, 2005

Gord,

Thank you, this helps!
-Me

Gord Dibben said:
Me

Select A1 then in Name Box to the left of the Formula Bar type in A1:A900 and
hit ENTER key.

Type your formula in A1 and hit CTRL + ENTER.

If formula is already entered in A1, hit F2 then CTRL + ENTER after selecting
the range.

Gord Dibben Excel MVP

Me · Mar 7, 2005

Earl,

Thanks a lot, this is what I was looking for!
-Me