How To Sort Alphabetically In Excel

how to sort alphabetically in Excel
Share on facebook
Share on twitter
Share on pinterest

In this guide, I am going to show you how to sort alphabetically and keep the rows together in Excel 2019. This should be fairly similar for  2010 and 2016  versions. However, there might be some differences in the older versions.

There are two methods in which you can sort alphabetically in Excel. One is more automatic, and the second one, more specific.

Method one: General 

To begin with, you can either select the entire workbook by clicking on the little corner square, and it highlights everything.

selecting the entire worksheet before alphabetizing in Excel
how to select entire worksheet

Or select only a specific section by a left click on the first cell and highlight the section you want.

selecting a section or column before alphabetizing in Excel
how to select a section of worksheet

After selecting the sections you want in your Excel worksheet, click on “Data” then go to the Data ribbon. There are two options which are quicksort. If you click on the top one [A to Z], it sorts in ascending order, and the bottom one [Z to A] sorts automatically into descending order. 

automatic alphabetizing option in Exce
alphabetical quick sort button

Method 2: Specific

Now, if you want to be a little more specific about how you want to sort your data, you can use the following method. Maybe you want to sort your data by first name then by city etc. 
First, select the section you want on your sheet and click on Sort. The Sort dialog box will appear.

alphabetizing in excel using sort option
sort button on the data ribbon

Depending on your data, it may or may not check the data header box on the top right corner. If you have headers, which are the descriptive titles on the top row, you check the ‘My data has headers’  box to exclude the header from the selections.

data header box and alphabetical sort option in Excel
my data has header box

Now, you can select what you want to Sort by: maybe you want to Sort by city, so you select city, then you can change the Order option,  AtoZ or ZtoA, etc.

details of alphabetical sort option in Exce
sort alphabetically by options

So, you have sorted your data by city, and you want to sort it by  first name. All you have to do is to Add  Level; select first name and choose the Sort option you want. You can add several levels. 

adding levels to alphabetical sort option in Exce
how to add levels

Once you make your selections, you click Ok. You are now back to your spreadsheet, and it is sorted out alphabetically first by city and then by first name.

the final results of alphabetizing in Excel and keeping the rows together
results after specific alphabetical sorting

Tip: You can change the order of the levels by simply selecting the column, then clicking on move up or move down button.

changing the order of the levels in the Sort dialog box
sort dialog box

This is how you alphabetize columns in Excel and keep the rows together. I hope you found this guide helpful. If you’d like to learn the basics about Excel don’t forget to check out our ‘Complete Guide to Excel Basics – Introduction to Excel with Examples’. You may also find our blog on ‘How to split cells in Excel’ helpful.  

If you are looking for Excel customization solutions and support, make sure you check out our Microsoft Excel Customization Services and Excel Support Services. 

Subscribe to our Newsletter

Share this post with your friends

Share on facebook
Share on google
Share on twitter
Share on linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *