AutoFill A to Z

[Hardeep kanwar]

There is an Option in Excel to AutoFill

Like want to Autofill Sunday ,Monday

or January, February
Or 1,2,3 like this

Is it Possible to Autofill A,b,c,d,e and on in a Column or row

Or I have type Manually

Thanks

Hardeep kanwar

 

[Sheeloo]

You ned to create a CUSTOM LIST...

Excel 2003
Tools->Options->Custom Lists tab

You can enter this in A1
=CHAR(64+ROW())
copy down till Row 26, copy & paste special as values and then import into a
custom list...

I could not create both A,B,C and a,b,c, at the same time through import
method...

 

[Jacob Skaria]

Dear Hardeep

To populate the series in a column starting from row 2 use
=CHAR(ROW()+63)
To populate the series in a row starting from col 2 use
=CHAR(COLUMN()+63)

Adjust the character code to make it between 65 and 90.

If this post helps click Yes

 

[Hardeep kanwar]

WOW..... So Simple

Thanks Sheeloo

You ned to create a CUSTOM LIST...

Excel 2003
Tools->Options->Custom Lists tab

You can enter this in A1
=CHAR(64+ROW())
copy down till Row 26, copy & paste special as values and then import into a
custom list...

I could not create both A,B,C and a,b,c, at the same time through import
method...

 

[Hardeep kanwar]

Thanks Jacob

Dear Hardeep

To populate the series in a column starting from row 2 use
=CHAR(ROW()+63)
To populate the series in a row starting from col 2 use
=CHAR(COLUMN()+63)

Adjust the character code to make it between 65 and 90.

If this post helps click Yes