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 in excel alphabetical


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.

how to make list in excel alphabetical with CHAR Function

  • After that, select both the cells and drag them down to the cell where the number 90 appears.

how to make list in excel alphabetical with CHAR Function

  • Now, type the following formula in cell C5.
=CHAR(B5)

how to make list in excel alphabetical with CHAR Function

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

how to make list in excel alphabetical Using CHAR Function

  • Now, select both the cells and drag them down to the cell where number 122 appears.

how to make list in excel alphabetical by formula

  • Type the following formula in cell C5.
=CHAR(B5)

  • After that, press the ENTER key.

  • Lastly, drag down to AutoFill rest of the series.

how to make list in excel alphabetical

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.

how to make list in excel alphabetical by sort

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

how to make list in excel alphabetical by sort

  • If we click the Sort option in the Data tab, then a dialogue box will pop up.

how to make list in excel alphabetical by sorting

  • From here, select the Name column and set the Order as A to Z, and click OK.

Simple.

Read More: How to Generate List Based on Criteria in Excel


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.

how to make list in excel alphabetical by Filter option

  • After that, click the drop-down button beside the Name header and select Sort A to Z.

how to make list in excel alphabetical by Filter option

Finally, our dataset will look like the following image.

how to make list in excel alphabetical by Filter option

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.


Download Practice Workbook


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.


Related Articles


<< Go Back to Make List in Excel | Excel Drop-Down List | Data Validation in Excel | Learn Excel

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

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo