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.
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.
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.
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.
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.
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.
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.
Step 4: Click OK when finished making your selections. Your data will now be sorted by Location first and then by Last Name.
You can organize data in other ways. For example, you can hide columns in Excel to obscure irrelevant data.
Are you making the most of your spreadsheets? Check out our Microsoft Excel tips and tricks.
Did you think hitting delete on your AI chatbot conversation actually makes it disappear? Georgia Tech researchers just proved that's not entirely true. They have built a forensic tool called ORISA that can dig deleted conversations from your phone and even rebuild them into a working chatbot session you can keep talking to.
How can ORISA bring deleted AI conversations back?
Touchscreen laptops have been around for years. You can get them in all sizes and shapes. Just not from Apple. For years, the Cupertino giant has treated the idea of a touchscreen MacBook the way I treat a meeting that could have been an email: with open contempt. However, Wednesday looks like the day the company could finally change its mind.
The latest Apple invite puts the “Pro and Tell” showcase in Los Angeles at 10 a.m. PT (1 p.m. ET) on October 28, 2026. Instead of a regular live-streamed keynote, it is an invitation-only, hands-on event for a handful of press and creators (similar to what the company did for the MacBook Neo earlier this year).
Two residents of Chicago have filed a lawsuit in the US over claims that robots run by Coco Robotics and Serve Robotics captured their facial and hand measurements without consent, bringing renewed attention to the food delivery robots. The cases raise a troubling question: If a robot delivers food to your door, can it also be gathering sensitive information about you?
According to a report by The Associated Press, the proposed class-action lawsuits were filed in Cook County on Oct. 9 and allege violations of Illinois’ Biometric Information Privacy Act. The complaints claim that the robots’ cameras and LiDAR sensors captured information on customers’ faces and hands as they approached the machines to pick up their orders. Both have denied the allegations.