Results 1 to 2 of 2

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

  1. #1
    Junior Member
    Join Date
    Feb 2008
    Answers
    6

    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..


  2. #2
    Expert Member
    Join Date
    Oct 2007
    Answers
    375

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact