# How to Make Alphabetical List in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

Steps:

• 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.
`=CHAR(B5)`

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

Steps:

• 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.
`=CHAR(B5)`

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

Steps:

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

Simple.

### Method 3: Make List Alphabetical Using Filter Option

We can also, use the Filter option to list our dataset alphabetically.

Steps:

• 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

## Practice Section

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.

## Conclusion

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.

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mahbubur Rahman

MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF