To make your dataset cool and presentable Sorting alphabetically is one of the most used functions in Excel. Throughout this article, we will learn how How to Make List in Excel Alphabetical. We will see sorting data alphabetically and also making an alphabet list using Excel formula. For your better understanding, we will use a sample dataset here.
Download Practice Workbook
3 Ways to Make List Alphabetical in Excel
Here, we will see the use of the CHAR function and learn codes for this function and also see how to make list alphabetical using Sort and Filter Option available in Excel.
Method 1: Make List Alphabetical Using CHAR Function
Suppose, we want to make a list of alphabets from A to Z. Typing all 26 letters is a tiresome process. How can we make the process easier, lets’s see.
1.1: Make a List with Capital Letters
First, we will see the CHAR function and its code for Capital letters.
- At first, type 65 and 66 in cells B5 and B6.
- After that, select both the cells and drag them down to the cell where the number 90 appears.
- Now, type the following formula in cell C5.
- Press the ENTER key.
- Finally, drag down to AutoFill rest of the series.
That’s it, we will get all the capital letters from A to Z. 65 is the Character code for the letter A in Excel and it continues to the number 90 which is the code for the letter Z.
1.2: Make a List with Small Letters
In this method, we will see how to generate a small letter using the CHAR function.
- At first, type 97 and 98 in cells B5 and B6. As 97 is the Character code for the letter a in Excel and it continues to number 122 which is the code for the letter z.
- Now, select both the cells and drag them down to the cell where number 122 appears.
- Type the following formula in cell C5.
- After that, press the ENTER key.
- Lastly, drag down to AutoFill rest of the series.
That’s it, we will get all the capital letters from a to z.
- Creating a Mailing List in Excel (2 Methods)
- How to Make a List within a Cell in Excel (3 Quick Methods)
Method 2: Make List Alphabetically Using Sort Option
Till now, we saw generating or making an alphabet list, now we will see, how to make list alphabetical using the Sort option which is available in Data Tab.
- Here, we can select the entire dataset or only the Name column to sort the list alphabetically. So, select the entire dataset and go to the Data tab.
- So, you can see, there are 3 options available. Clicking the 1 marked option will automatically sort our list from A to Z.
- And 2 marked options will sort the list in descending order from Z to A which is the last name Kate will appear on top of the list.
- If we click the Sort option in the Data tab, then a dialogue box will pop up.
- From here, select the Name column and set the Order as A to Z, and click OK.
Method 3: Make List Alphabetical Using Filter Option
We can also, use the Filter option to list our dataset alphabetically.
- Select the entire dataset including the header and go to Data > Filter.
- After that, click the drop-down button beside the Name header and select Sort A to Z.
Finally, our dataset will look like the following image.
The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.
That’s all for the article. These are 6 different methods for how to make list in Excel alphabetical. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.