Sort a Range in Sheets?
Sorting in Google Sheets scrambles data when you sort one column but not the rest — names detach from their rows and the spreadsheet becomes fiction. The fix is sorting the whole range together, with the header row protected. This guide shows the safe way to sort and the multi-column sort for tie-breakers.
TL;DR / Quick Fix
Quick fix: to sort in Google Sheets without scrambling your data, select the full range including all columns, then Data, Sort range. Tick 'Data has header row' if the first row is labels. Sorting one column alone misaligns rows — select everything that belongs together first.
Follow these steps
- Select the full range. Click and drag across every column that belongs together — names, dates, amounts, all of it. Sorting a partial range is how rows get scrambled.
- Open Sort range. Go to Data, then 'Sort range' (not 'Sort sheet,' which sorts everything). Choose whether to sort A to Z or Z to A on the key column.
- Protect the header row. Tick 'Data has header row' if your first row holds labels. Without it, your headers sort into the data like any other row — the classic embarrassing result.
- Sort by multiple columns. Click 'Add another sort column' for tie-breakers — sort by last name, then first name. Multi-level sorts are what make big lists actually readable.
- Check formulas after sorting. Formulas with fixed row references can point at the wrong rows after a sort. Scan the results — especially totals — before trusting a freshly sorted sheet.
- Use filter views for shared sheets. On a shared spreadsheet, your sort rearranges it for everyone. Filter views let you sort privately without disturbing collaborators — the polite option.
What NOT to do
- Do not sort a single column alone. This is the number one Sheets disaster — names detach from their data and the sheet becomes unreliable.
- Do not forget the header tick. Headers sorted into the data look absurd and break every formula referencing those rows.
- Do not sort a shared sheet without a filter view. Your personal sort becomes everyone's confusion — filter views keep your view private.
- Do not trust totals blindly after sorting. Verify sums and lookups still reference the right rows — sorting moves data, not the formulas pointing at it.
Frequently asked questions
What is the difference between Sort range and Sort sheet?
Sort range sorts only your selection; Sort sheet sorts the entire sheet by one column. Range is safer — sheet-wide sorts scramble unrelated tables sharing the sheet.
Can I undo a bad sort?
Yes, immediately: Ctrl+Z (Cmd+Z on Mac) right after. But if you kept working, the original order may be unrecoverable — which is why selecting the full range matters.
How do I sort numbers correctly?
Select the range, Data, Sort range, and pick the number column. Sheets handles numbers fine — but numbers stored as text sort oddly (1, 10, 2), so check the format first.