Expand formula in EXCEL

Hi.
Is it possible someway to expand a formula in EXCEL downward, (A1--> A100),
but the values of cells have to be read from a horizontal line? (That means:
A1=B1, A2=C1, A3=D1,��������.A100=CW1).
I try some forms of $A1, A$1, e.g. (expand) but without any result.
Thank you.

Put in A1

=OFFSET($A$1,,ROW(A1))

then copy downward

"?????" <@discussions.microsoft.com> wrote in message
news:[email protected]...
> Hi.
> Is it possible someway to expand a formula in EXCEL downward, (A1-->
> A100),
> but the values of cells have to be read from a horizontal line? (That
> means:
> A1=B1, A2=C1, A3=D1,.........A100=CW1).
> I try some forms of $A1, A$1, e.g. (expand) but without any result.
> Thank you.
>

Hi

Switch to R1C1 notation (Tools - Options menu).
Enter in Cell A2 (Now named R2C1):
R1C2
Fill this down. Now, using Edit - replace, replace R1 with =R1 in these
cells.

HTH. Best wishes Harald

"?????" <@discussions.microsoft.com> skrev i melding
news:[email protected]...
> Hi.
> Is it possible someway to expand a formula in EXCEL downward, (A1-->
A100),
> but the values of cells have to be read from a horizontal line? (That
means:
> A1=B1, A2=C1, A3=D1,.........A100=CW1).
> I try some forms of $A1, A$1, e.g. (expand) but without any result.
> Thank you.
>