# 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?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

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

1,102,134
Messages
5,484,929
Members
407,474
Latest member
Pam Sander

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...