How to copy values in various rows automatically

[Guest]

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]

Me,

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

 

[Guest]

Earl,

Thank you very much, it works!
-Me

Me,

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

 

[Gord Dibben]

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

 

[Guest]

Gord,

Thank you, this helps!
-Me

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

 

[Guest]

Earl,

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