Skip to main content

How to alphabetize data in an Excel spreadsheet

how to alphabetize in excel microsoft
PixieMe/Shutterstock

Manually organizing data in Microsoft Excel is a real pain. That's why we don't recommend doing it. One simple task, learning how to alphabetize in Excel, is not necessarily as intuitive as we would like. Here's how to get things sorted in a logical, alphabetical order.

Difficulty

Easy

Duration

5 minutes

What You Need

  • Microsoft Excel

Using the alphabetize buttons

The easiest way to alphabetize in Excel is to use one of the simplified sorting buttons located under the Data tab in the menu at the top of the spreadsheet. It is most useful for when you want to organize columns in alphabetical order. Continue on to read about the Sort command for a better idea of how to organize rows in Excel into alphabetical order.

Step 1: These buttons default to either an A-Z or a Z-A sorting order and can either sort a single column or sort multiple columns in a table. In the latter case, the tool defaults to sorting by the left-most column.

Simplified sort buttons in Microsoft Excel.
Image used with permission by copyright holder

Step 2: To sort using one of the buttons, select your column or table. In this case, we're using the second table in the sample spreadsheet.

Selecting a tablet in Microsoft Excel.
Image used with permission by copyright holder

Step 3: Click the A-Z button. This will alphabetize the table by the contents of the First Name column. You could also sort in reverse order by using the Z-A button.

Data alphabetized by first column in Microsoft Excel.
Image used with permission by copyright holder

Alphabetize using the Sort command

If you want more control over how your data is alphabetized, use the Sort command. This will even allow you to alphabetize rows in Excel.

Step 1: Select your table and then click the Sort button. This will open the Sort dialog box. By default, the tool will sort by the left-most column in A-to-Z order, and it will assume you have data headers that should be used in the sorting process. If you don't have headers, then deselect My data has headers.

Selecting a table and using the Sort button in Microsoft Excel.
Image used with permission by copyright holder

Step 2: Click the Options button. Here, you can choose whether your data is case sensitive and whether to sort top to bottom or left to right.

Sort options in Microsoft Excel.
Image used with permission by copyright holder

Step 3: In our example, we're going to sort by Location and then by Last Name. To do so, we'll select Location in the first Sort by drop-down box. Then, we'll click Add Level to select Last Name from the drop-down box. You can also use the Delete Level and Copy Level options as necessary.

Sorting options selected in Microsoft Excel.
Image used with permission by copyright holder

Step 4: Click OK when finished making your selections. Your data will now be sorted by Location first and then by Last Name.

Table sorted by options in Microsoft Excel.
Image used with permission by copyright holder

For more on how to use Excel, check out our guide on how to password protect an Excel file.

Mark Coppock
Mark has been a geek since MS-DOS gave way to Windows and the PalmPilot was a thing. He’s translated his love for…
How to password-protect an Excel file on Windows and Mac
A person using a laptop while lounging on a couch.

If you use a computer, you probably have some Microsoft Excel documents on your Mac or PC that you wouldn’t want other people to find and read.

After all, Excel serves not only the average person, but also businesses, government institutions, and millions of other folks worldwide. Whether you’re creating graphs, converting PDFs, or just inputting rows and rows of data, the best way to keep that information safe is to learn how to password-protect an Excel file.

Read more
Here’s how to quickly and easily convert a PDF to Excel
Spreadsheet on a laptop on a table.

Just because your co-worker sent you a PDF file instead of the Excel document you wanted doesn't mean you're actually stuck with it. In this guide, we'll teach you how to convert a PDF into an Excel document using a few quick and easy steps. We'll even teach you a few different ways to do it.

If you don't want to go to the trouble of converting the PDF (whether password-protected or not) and would rather just edit it as is, we have a guide to the best PDF editors, too.

Read more
How to use Microsoft Copilot in Teams, Powerpoint, Excel, and more
Using Windows 11 copilot to summarize a document.

The Windows 11 Copilot AI is Microsoft's big push to bring modern artificial intelligence to its flagship operating system — and it goes far beyond the early integrations of ChatGPT through Bing Chat. This isn't your granddad's Clippy, it's a whole new way of augmenting Windows with truly smart functions.

Here's how to use the Microsoft Copilot AI in Windows 11 to make your life easier and more efficient.

Read more