AutoFill A to Z

  • Thread starter Thread starter Hardeep kanwar
  • Start date Start date
H

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
 
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...
 
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
 
WOW..... So Simple

Thanks Sheeloo

Sheeloo said:
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...
Click to expand...
 
Thanks Jacob

Jacob Skaria said:
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
Click to expand...
 
Back
Top