Expand formula in EXCEL

[Guest]

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.

 

[JON JON]

Put in A1

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

then copy downward

 

[Harald Staff]

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