-
Junior Member
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..
-
Expert Member
Re: Create automatic series of a b c..z in excel
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.....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules