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

move your mouse over the bottom right corner of the cell containing the formula.
The icon should change to a + sign.. double click it. This will fill the formula for as many rows as there are data in the column immediately to the left of it.
(dont try to fill a formula if the column to the left has blank cells)

Me,

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

"Me" <Me@discussions.microsoft.com> wrote in message
news:6EEF5057-6009-4187-9760-CC58E6312790@microsoft.com...
>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" <Me@discussions.microsoft.com> wrote in message
> news:6EEF5057-6009-4187-9760-CC58E6312790@microsoft.com...
> >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" <Me@discussions.microsoft.com> wrote in message
> news:6EEF5057-6009-4187-9760-CC58E6312790@microsoft.com...
> >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" <Me@discussions.microsoft.com> 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" <Me@discussions.microsoft.com> 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
>
>