Formula Drag Across Link Down

[Bazy2k]

Hi Guys

I want to drag my formula across a row but the items i want them to link to
are displayed horizontally?

ie.. i want to drag the formula across and sequentially increase like this.

=a1,=a2,=a3,=a4,=a5,=a6 and so on across, without having to write it obv!

Can this be done?

 

[Mike H]

Hi,

Put this in a cell and drag right and you will get a1, a2 etc

=INDIRECT(ADDRESS(COLUMN(A1 ),1))

Mike

 

[Dave Peterson]

I'd put
$=a1
in the first cell
drag across as far as I needed
Then select those cells
edit|Replace
what: $
with: (leave blank)
replace all