Docs · guide

How to alphabetize in Excel, without scrambling your rows

By Alberto Gulotta · Updated 4 September 2026 · 9 min read

Learning how to alphabetize in excel takes one click. Learning it without silently destroying the relationship between a name and the row it belongs to takes one extra second of care, and Microsoft puts the whole of that care into the first word of its first step.

The distinction is this. If you click a single cell, Excel looks around it, works out the block of data it belongs to, and moves whole rows — so each name keeps its address, its total, its date. If you select the column by clicking its letter, you have told Excel that the column is the thing being sorted, and it will reorder that column while everything beside it stays where it was.

The result is a spreadsheet where every row is now wrong, nothing looks broken, and there is no error message. It is the most quietly destructive thing a spreadsheet does, and it is why this guide exists rather than the one-click instruction.

That third step is ours rather than Microsoft’s, and it takes two seconds: before sorting, note what is in the row next to your first entry. After sorting, find that entry and check its neighbour is the same. If it is not, undo immediately — the fix is free for as long as you have not saved and closed.

Both of those come from the same place, which is data that arrived from somewhere else. A download from a bank, an export from another system, a table copied out of a PDF — all of them produce columns where some values are text and some are numbers, and where invisible spaces are common. If a sort produces an order that makes no sense, the data is telling you something about itself before the sort is telling you anything about the order.

Two things that make sorting reliable from then on. Turn the range into a proper table, which makes the header a header and keeps rows attached whatever you do afterwards. And avoid merged cells entirely, because a merged block is not a row and sorting either refuses or misbehaves — that has its own guide in this section.

Sorting by more than one thing. Alphabetical by surname and then by first name, or by department and then by name, is done through the full Sort dialog rather than the A-to-Z button, which handles one level. The principle is the same and so is the precaution: click one cell inside the data first.

Undo is the real safety net, and it is a short one. A sort can be undone with a keystroke while the file is open and cannot be undone at all once you have saved, closed and reopened. For a spreadsheet that matters, the two-second habit is to make a copy of the sheet before doing anything structural to it — sorting included.

Google Sheets asks the same question in different words. Its sort dialog offers “Data has header row” where Excel offers “My data has headers”, and Google’s instruction adds a step Excel does not: “if your sheet includes a header row, freeze the first row” before sorting. Freezing is what keeps the header out of the sorted range, which is the protection Excel’s tick box provides by a different route. Two programs, one trap, two names for the switch that avoids it.

The steps and both documented failures on this page are quoted from Microsoft’s own Excel documentation, read on 22 August 2026. The explanation of why selecting a whole column scrambles the rows, and the check afterwards, are ours.

Not covered here. It will not hand you a one-click instruction and stop. The one click is fine; the selection you make before it decides whether your data survives.

It will not blame Excel for a strange order. Both common causes are documented by Microsoft as potential issues, and both come from the data rather than the sort.

And it will not suggest an add-in for something on the Data tab. What holds instead is simple: the steps and both documented failures are quoted from Microsoft’s own Excel documentation, with the date it was read.