How to copy values in various rows automatically
 

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

Me,

Select A1. Drag the Fill Handle (lower right corner button) down.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Me" wrote in message
...
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,

Thank you very much, it works!
-Me


"Earl Kiosterud" wrote:

Me,

Select A1. Drag the Fill Handle (lower right corner button) down.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Me" wrote in message
...
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

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

On Fri, 4 Mar 2005 14:25:01 -0800, "Me" wrote:

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

Gord,

Thank you, this helps!
-Me


"Gord Dibben" wrote:

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

On Fri, 4 Mar 2005 14:25:01 -0800, "Me" wrote:

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,

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


"Earl Kiosterud" wrote:

Me,

Select A1. Drag the Fill Handle (lower right corner button) down.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Me" wrote in message
...
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