Autofill Handle to Increment Column Letters - how can I achieve this?

[PP3321]

I want to increment by Column Letters using Autofill Handle.

=A$2
=B$2
=C$2

Can anyone please tell me how to achieve this?

 

[bosco_yip]

Try........

A2 =1

B2 =2

C2 =3

In A4, copy down :

=OFFSET(A$2,0,ROWS($1:1)-1)

Regards

 

[PP3321]

Thank you!!!

 

[xlstime]

Hey PP,

try Address function to achieve this

=ADDRESS(1,ROW(),2)

I want to increment by Column Letters using Autofill Handle.

=A$2
=B$2
=C$2

Can anyone please tell me how to achieve this?

View attachment 33035

 

[PP3321]

Thank you!

 

[xlstime]

You can use INDIRECT function with this

Thank you!