Create automatic series of a b c..z in excel

I have tried to create automatic series of a b c..z in excel by dragging cells.
But not coming properly..
Please help in this matter..

Kevin,

The reason why excel does not autofill an automatic Series of alpahbets is because there are few autofill Series created in Excel by default. These include Numbers, Dates, Months etc but alphabet series are not present.

You can create a Custom list to accomplish your purpose. Go to Tools - Options and select Custom List.

Select New List. Enter the alphabet series (Remember to hit the Enter key after every entry) and click on Add. This creates a Alphabetical series.

Now you can use the fill handle to create an automatic Series of alphabets further on for all times.

Cheers.....