Thread: AutoFill A to Z
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Hardeep kanwar Hardeep kanwar is offline
external usenet poster
 
Posts: 65
Default AutoFill A to Z

WOW..... So Simple

Thanks Sheeloo

"Sheeloo" wrote:

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" wrote:

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