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 to make an alphabetical list in Excel. We will see sorting data alphabetically and also making an alphabet list using the Excel formula. For your better understanding, we will use a sample dataset here.
How to Make List Alphabetical in Excel: 3 Ways
Here, we will see the use of the CHAR function and learn codes for this function, and also see how to make a list alphabetically using the 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, let’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.
Read More: How to Make a Numbered List in Excel
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.
Read More: How to Make a Bulleted List in Excel
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.
Read More: How to Make a To Do List in Excel
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.
Download Practice Workbook
That’s all for the article. These are 6 different methods for how to make an alphabetical list in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.
- How to Create List from Range in Excel
- How to Make a Comma Separated List in Excel
- How to Make a Price List in Excel
- Create a Unique List in Excel Based on Criteria
- How to Create a Contact List in Excel
- How to Make a List within a Cell in Excel