# Using autofill on cells with formulas

#### jmancha

##### New Member
Is there a way. . .

I am in Cell A1 and the formula is =E1. I want to copy my formula down but instead of the row # changing from E1, E2, E3, etc. I need the COLUMN to change from E1, F1, G1, H1, etc.

Is this possible?

##### Active Member
Hi
is this what you mean
Code:
``=INDIRECT("E"&ROW())``
Or

Code:
``=INDIRECT(ADDRESS(ROW(),COLUMN()+4))``

Last edited:

#### Fluff

##### MrExcel MVP, Moderator
=INDIRECT("R1C"&ROW()+4,0)

#### jmancha

##### New Member
Thank you! The formula works in A1 but when I drag it to A2 the E does not change to F. . .

Have you try

Last edited:

#### jmancha

##### New Member
It is still copying down the row but keeping the column the same. So, It is giving me E1, E2, E2 when I need E1, F1, G1, etc.

#### Fluff

##### MrExcel MVP, Moderator
Have you tried the formula in post#3?

#### jmancha

##### New Member
I did try all of them (thank you all). After trying those got me thinking. . . INDEX(\$1:\$1, 1, ROW(1:1))

This Worked!!

#### salim hasan

##### Board Regular
Try this formula From Column(E) to Column(Z)
Code:
``=INDIRECT(CHAR(69+ROWS(\$A\$1:A1)-1)&1)``
Or This One Column(E) to Any where
Code:
``=OFFSET(\$A\$1,,ROWS(\$A\$1:A1)+3)``

Last edited:

#### Fluff

##### MrExcel MVP, Moderator
I did try all of them (thank you all). After trying those got me thinking. . . INDEX(\$1:\$1, 1, ROW(1:1))

This Worked!!
Glad you sorted it & thanks for the feedback