How to Sort a List in Excel, Google Sheets, and Word
Sorting looks like a one-click job until a column moves without its neighbours, a header becomes part of the data, or a list of names sorts in an order nobody expected. The software is usually doing exactly what it was told. The problem is that the range, the header, or the data type was not what the person assumed.
If you only need the finished list, paste it into the Alphabetical Order Tool and skip the spreadsheet. If the list has to stay in a table, the notes below apply.
Quick answer
Select the whole table or the full column, not a single cell. Tell the software whether the first row is a header. Check for leading spaces, numbers stored as text, and mixed case before sorting. After the sort, verify that each row still belongs together and that no blank row split the range.
Excel and Google Sheets
In Excel, select a cell inside the table and use Data > Sort. Excel usually detects the range and the header, but confirm both in the dialog. If you select only one column and choose “Continue with the current selection”, the other columns will not move with it. That is the most common way a table gets scrambled.
In Google Sheets, select the range and use Data > Sort range. If the first row is a header, tick “Data has header row”. Then choose the column and the order. For a simple A-to-Z sort, the toolbar button is fine, but it still sorts the selected range rather than the whole sheet. Select the full table first.
Microsoft Word
Word can sort paragraphs, lists, and tables. Select the text, then use Table > Sort or Home > Sort. In a table, Word asks whether the first row is a header. In a plain list, each paragraph is one record, so a list with line breaks inside an entry will sort incorrectly. Remove the internal line breaks or convert the list to a table first.
Word’s sort dialog also lets you sort by a second column. That is useful for a list of names with a separate surname column, but it is not a substitute for deciding how particles and hyphenated names should be handled.
Why a sort looks wrong
Leading spaces are the most common cause. ” Smith” sorts before “Adams” because the space comes before the letter. Use Find and Replace to remove leading spaces, or a formula such as TRIM to create a clean sort key. Non-breaking spaces and tabs cause the same problem and are harder to see.
Numbers stored as text sort lexicographically: “10” comes before “2”. Convert the column to a number, or use a helper column with a numeric value. Mixed case is usually not a problem in modern Excel and Sheets, because the sort is case-insensitive by default, but it can matter in other tools.
Accented letters and names with apostrophes can also sort differently depending on the locale. Check the entries around the boundary rather than assuming the whole list is wrong. A single unusual character can make a correct sort look broken.
When a dedicated tool is faster
A spreadsheet is the right place for a list that has to stay connected to other columns. A dedicated tool is faster for a plain list of words, names, or titles that you need to clean and paste somewhere else. It also avoids the header and range problems entirely.
Use the Alphabetical Order Tool for a one-off sort, then paste the result back. If the list contains numbers, hyphens, or leading articles, decide the rule first; see Alphabetical Order Rules for Numbers, Hyphens, and Articles. For the wider method, read How to Alphabetize Names, Titles, and Lists Correctly.
Common questions
Why did my spreadsheet sort scramble the rows?
The sort probably applied to one column rather than the whole table. Excel and Google Sheets sort the selected range; if only one column is selected, the neighbouring cells stay where they are. Undo the sort, select the full table including the header, and tell the dialog that the first row is a header.
Why does 10 sort before 2 in my list?
The numbers are stored as text, so the software compares characters rather than values. "10" begins with 1, which comes before 2. Convert the column to a number or use a helper column with a numeric value. A leading apostrophe or a cell formatted as text has the same effect.
When should I use a dedicated alphabetical tool instead?
Use a dedicated tool for a plain list that you need to clean and paste somewhere else, especially when the list has inconsistent spacing or mixed formats. A spreadsheet is better when the list must stay connected to other columns or be updated repeatedly.