Skip to main content

How to alphabetize data in an Excel spreadsheet

Microsoft Excel is as good at working with text as it is with numbers, giving you the ability to manipulate both kinds of data in the ways that make the most sense for your needs. The ability to easily alphabetize data in Excel is a prime example.

Related Videos

Difficulty

Easy

Duration

5 minutes

What You Need

  • Microsoft Excel

Using the alphabetize buttons

The easiest way to alphabetize data 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.

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.

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.

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.

Alphabetize using the Sort command

If you want more control over how your data is alphabetized, use the Sort command.

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.

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.

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.

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.

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

Editors' Recommendations

Your Windows 11 screenshots may not be as private as you thought
Person sitting and using an HP computer with Windows 11.

When you capture a screenshot and crop out sensitive information, it's still possible to recover a portion of the image that was supposedly removed in some circumstances.

This isn't the first time redacted documents have turned out to have left hidden data intact and readable with the right tools and knowledge. A recent bug in Google's Markup tool for the Pixel phone, humorously dubbed the "Acropalypse," shows this issue might be surprisingly common.

Read more
Best VPN services 2023: today’s top picks
best VPN services

People around the world use the internet for everything today, including work, education, shopping, socializing, and managing finances. It goes without saying, then, that ensuring your online privacy is more pressing than ever. Even if you lack technical skills, there's an affordable and easy security solution: a virtual private network, better known as a VPN. By using a good VPN, you can protect your devices and hide your online activities from cyber-criminals, network snoops, online busybodies, institutional censors, and other unwanted pests. But with so many options available, it can be challenging to choose the right VPN for your needs and budget. To help you make an informed decision and maybe even save you some money, we've curated a comprehensive list of the best VPN services complete with details on their pricing, features, and more.
Best VPN 2023

NordVPN
ExpressVPN
Surfshark
IPVanish
AtlasVPN
Hotspot Shield
PrivadoVPN
CyberGhost
PureVPN
TunnelBear
Private Internet Access
Kaspersky VPN

Read more
Adobe Firefly brings text-to-image AI to the masses, with artist ethics in mind
AI-generated imagery in Nvidia's press photo for AI Foundations.

Adobe Firefly was announced today by Adobe, as the company attempts to capitalize on the surge in interest in generative AI. The text-to-image model is only in beta, but will be coming first to Adobe Express, the company's simplest and most user-friendly application.

The set of tools will function a lot like many of the other popular text-to-image models, such as Stable Diffusion or Midjourney. The difference here, however, is that Firefly is built from the ground up by Adobe to be used within its creative applications. That means Firefly will be both highly accessible to beginners and include important ethical considerations for artists.

Read more