How to Make Alphabetical List in Excel (3 Ways)

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.

how to make list in excel alphabetical


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.

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.


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 Numbered List in Excel (8 Methods)


Similar Readings


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 (4 Methods)


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 (3 Easy Methods)


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


Related Articles

Mahbub
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo