Expand formula in EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

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