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?