How to Sort Alphabetically in Excel — Complete Guide (2026)

Sorting data alphabetically is one of those Excel skills you'll use constantly — whether you're organizing a contact list, ordering product names, or cleaning up a report before sending it to your manager. Once you know the fastest method for your situation, it takes seconds. But there's more than one way to do it, and picking the wrong approach can leave you with a mess or — worse — sorted data that looks right but isn't.

The two most common methods are the Data tab ribbon and the keyboard shortcut. If you've got a single column of names and just want A-to-Z order fast, the ribbon button or shortcut (Alt+A+S+A) does the job in one move. No menus, no dialogs — just sorted data.

If you're sorting a full table with multiple columns and want to preserve row integrity (so your contact's name stays matched to their email and phone number), you'll use the Sort dialog from Data → Sort instead. The dialog gives you more control: you can pick which column drives the sort, set a secondary sort for tiebreakers, and even sort by cell color or icon rather than value.

Things get a bit trickier when you're dealing with full names. Excel sees "John Smith" as a single text string, so sorting a column of full names gives you A-to-Z by first name — not last. "Aaron Miller" comes before "Beth Adams" because A comes before B. That's fine if you want first-name order.

But most directories, rosters, and employee lists need last-name order — and for that, you'll either need to separate first and last name in Excel into different columns first, or use a helper column formula to extract just the last name and sort by that. Both approaches are covered in detail below.

And if you're on Excel 365, there's a third option worth knowing: the SORT function. Unlike the ribbon sort — which gives you a static, one-time reorder — =SORT() returns a dynamic sorted list that updates automatically whenever your source data changes. You add a new name to the list and it drops straight into alphabetical position without you touching anything. It's a game-changer for dashboards and live reports where the underlying data keeps moving.

One more thing before diving in: alphabetical sorting in Excel is case-insensitive by default. "apple" and "Apple" are treated identically — they sort in the same position. If case matters for your data (product codes, system identifiers), there's an option in the Sort dialog to enable case-sensitive sorting. It's off by default, but easy to turn on when you need it.

This guide covers every approach: quick A-Z sorts, keyboard shortcuts, right-click methods, sorting by last name with a helper column, multi-level sorts for full names, the SORT function for live data, case-sensitive sorting, and common reasons your sort might not be working. Whether you're using a basic Excel spreadsheet or a formatted table, there's a method here that fits your workflow. Check the how to sort in excel if you want a broader look at all sorting options beyond alphabetical — by date, number, color, and custom lists.

Basic A-Z Sort and the Keyboard Shortcut

The fastest way to sort alphabetically in Excel is to click any cell in the column you want to sort, then head to the Data tab and hit Sort A to Z (the button with the A-over-Z arrow). Excel sorts the entire column — or the entire table if your data has multiple columns — while keeping rows intact. That last part matters: if column A has names and column B has emails, Excel moves both together so your data stays aligned. No mismatched rows, no orphaned values.

Here's the step-by-step for a single column:

1. Click any cell in the column you want to sort (e.g., a name column).
2. Go to the Data tab on the ribbon.
3. Click Sort A to Z (looks like A↓Z with a down arrow).
4. If Excel detects adjacent data, it'll ask whether to expand the selection — choose Expand the selection to sort the whole table together. If you choose "Continue with current selection", only the column you clicked gets sorted and your row data falls out of alignment — almost always not what you want.

The sort happens instantly. No confirmation dialog, no progress bar — Excel just reorders your rows and you're done. If it didn't sort the way you expected, Ctrl+Z undoes it immediately.

Keyboard Shortcut: Alt+A+S+A

If you'd rather keep your hands on the keyboard, the excel alphabetical order shortcut is Alt+A+S+A for A to Z, and Alt+A+S+D for Z to A. These are sequential key presses — hold Alt, tap A (Data tab), tap S (Sort A to Z menu), then tap A again (Sort A to Z) or D (Sort Z to A). You don't hold them all simultaneously — it's a ribbon navigation sequence, not a chord.

This shortcut works in all modern Excel versions and is probably the quickest way to do an excel sort alphabetically once you've memorized it. Click your column first, then fire the shortcut — done in under two seconds. Worth memorizing if you sort frequently.

There's also Ctrl+Shift+L to toggle AutoFilter on your range, which adds dropdown arrows to headers — those dropdowns include Sort A to Z and Sort Z to A options too. Useful if you're already filtering and want sorting from the same interface.

Right-Click Method

There's a third option that many users overlook: right-click the column header (the letter at the top, like column A), then choose Sort → Sort A to Z. This is handy when you're already working with your mouse and don't want to navigate to the Data tab. Same result, different path. Note that right-clicking the header selects the entire column — if your data has a header row, Excel usually recognizes it automatically and keeps it at the top.

You can also right-click any cell within the data (not the header) → Sort → Sort A to Z. This works the same way. Excel uses the column of the cell you right-clicked as the sort key and expands the selection to include the full table automatically.

For a quick how to sort a column in excel, any of these three methods works fine. The ribbon and shortcut are faster for keyboard users; right-click is more intuitive for mouse-first workflows. Pick whichever fits how you work — they all produce identical results.

Sorting Names Alphabetically: First Name vs. Last Name

Sorting a column of first names is easy — Excel's A-to-Z sort handles it directly. But full names ("Sarah Johnson", "Mike Adams") are trickier because Excel treats the whole string as one unit. When you sort A-to-Z on a full name column, you're sorting by first name. "Aaron Lee" comes before "Beth Carter" because A precedes B. That's often fine for internal lists, but school rosters, employee directories, and contact databases almost always need last-name order.

The cleanest long-term solution is to store first and last names in separate columns from the start. If you haven't done that yet, check out how to separate first and last name in Excel — it covers the Flash Fill method (fast, no formulas) and text-to-columns approaches that split your existing data in seconds.

Helper Column Method for Last Name Sort

If splitting the names isn't practical right now, use a helper column. Here's the process:

1. Insert a blank column next to your names (or use any empty column).
2. In the first data row, type: =MID(A2,FIND(" ",A2)+1,100)
3. This extracts everything after the first space — your last name.
4. Copy that formula down to all rows with names.
5. Click any cell in the helper column.
6. Go to Data → Sort A to Z.
7. When prompted, choose Expand the selection so the original name column moves with it.

Your names are now sorted by last name. The helper column can stay hidden (right-click → Hide) or you can delete it after sorting — just paste the helper column values back over itself first (Paste Special → Values) if you want to lock in the results before deleting.

Multi-Level Sort for Full Names

If you have separate First Name and Last Name columns and want to sort by last name, then first name as a tiebreaker (so two people named "Smith" get sorted correctly by first name), use the Sort dialog:

1. Click anywhere in your data.
2. Go to Data → Sort (opens the Sort dialog).
3. In the first sort level, set Column to Last Name, Order to A to Z.
4. Click Add Level.
5. In the second level, set Column to First Name, Order to A to Z.
6. Click OK.

Excel sorts by last name first — and for any ties, it then sorts by first name. This is how you'd sort names alphabetically in Excel the "correct" way for a proper directory. Excel supports up to 64 sort levels, though most use cases need only two or three. If you're also working with formulas that count across your sorted data, the countifs excel function can help you tally results within your sorted ranges.

One thing worth noting: the multi-level sort dialog is non-destructive — it reads your data, sorts it in memory, and writes back the new order. You're not deleting or overwriting values. If the result isn't what you expected, Ctrl+Z reverts it immediately. So don't be afraid to experiment with sort levels until you get the order right.

The SORT Function for Dynamic Alphabetical Sorting

The SORT function — available in Excel 365 and Excel 2021 — is a different animal from the ribbon sort. Instead of reordering your existing data in place, it outputs a new sorted version of your range into a separate area of the spreadsheet. The output is dynamic: change the source, the sorted output changes too. Add a row, delete a row, edit a cell — the sorted output updates automatically. No button-pressing required. For the full syntax breakdown, see the dedicated Excel SORT function guide.

Basic usage for alphabetical (A-Z) sort:

=SORT(A2:A20)

That's it. Excel 365 spills a sorted copy of your range below (or beside) the formula cell. By default, SORT sorts ascending (A to Z) — same as clicking Sort A to Z in the ribbon. To sort Z to A, add a -1 third argument:

=SORT(A2:A20,1,-1)

The second argument (1) tells SORT to sort by the first column of the range. The third (-1) reverses the order to Z-A. For a two-column range where you want to sort by the second column alphabetically:

=SORT(A2:B20,2,1)

This sorts a two-column name/email range alphabetically by column 2 (email), keeping names matched to their emails in the output. The source data stays untouched.

One important caveat: the SORT function's output is read-only. You can't click into the spilled results and edit them directly. Changes go into the source range, not the output. That's actually the point — the output is a live view of your data in a different order, not a copy you'd maintain separately.

SORT also combines nicely with FILTER for more powerful queries. For example, =SORT(FILTER(A2:B20,B2:B20>50),1,1) filters rows where column B is over 50, then sorts the filtered results alphabetically by column A. This kind of dynamic filtered-and-sorted output would require manual steps with the ribbon approach every time your data changes.

Case-Sensitive Alphabetical Sort

By default, Excel's alphabetical sort is case-insensitive — "apple" and "Apple" sort identically. For most name and text data, that's exactly what you want. But if case matters for your data (product SKUs, system identifiers, anything where "ABC123" and "abc123" are genuinely different values), you can enable case-sensitive sorting:

1. Go to Data → Sort to open the Sort dialog.
2. Click Options… in the top-right of the dialog.
3. Check the Case sensitive box.
4. Click OK, then set your sort column and order as usual.

With case-sensitive sorting on, Excel treats lowercase and uppercase as different characters. Lowercase letters sort before their uppercase equivalents — "apple" before "Apple", "zebra" before "Zebra". This matches standard ASCII ordering where lowercase characters have higher code values than uppercase.

Note: the SORT function doesn't support case-sensitive sorting — it's always case-insensitive. For case-sensitive dynamic sorting, you'd need a helper column converting text to comparable values. An edge case most users won't encounter.

Why Your Alphabetical Sort Isn't Working

A few common culprits when sorting produces wrong results or no change at all:

• Text stored as numbers: If a cell shows a green triangle in the corner, Excel thinks it's a number stored as text (or vice versa). Use Data → Text to Columns or the VALUE() function to fix these before sorting.
• Leading spaces: A name like " John" (space before J) sorts before "Alice" because the space character (ASCII 32) comes before any letter. Wrap your data in =TRIM() to strip leading and trailing spaces.
• Mixed data types: A column mixing numbers and text sorts with all numbers first (or last depending on version), then text — not in a natural mixed order.
• Merged cells: Merged cells in the sort range cause Excel to throw a "Cannot do that to a merged cell" error. Unmerge them first (Home → Merge & Center → Unmerge Cells), sort, then re-merge if needed.
• Blank rows: Blank rows within your data act as boundaries — Excel may only sort the block above the blank row. Delete blank rows within the data before sorting.

After a sort reshuffles your table, you may need to adjust column widths to fit the new content. Knowing how to change column width in Excel keeps your data readable without manual dragging. And if you need to clean up extra rows after sorting — duplicate headers, blank rows that surfaced at the top — the keyboard shortcut to delete row in Excel speeds that cleanup considerably.