Expand formula in EXCEL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Νικος - 31 Jul 2006 06:34 GMT

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.

Reply to this Message

JON JON - 31 Jul 2006 06:41 GMT

Put in A1

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

then copy downward

> Hi.
> Is it possible someway to expand a formula in EXCEL downward, (A1-->
[quoted text clipped - 4 lines]
> I try some forms of $A1, A$1, e.g. (expand) but without any result.
> Thank you.

Reply to this Message

Harald Staff - 31 Jul 2006 11:49 GMT

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:4FA7B8F6-B6CC-401C-813C-3A5D5B904908@microsoft.com...

> 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.

Reply to this Message