How to sort by multiple columns in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Steps
-
1
Select the range or click inside the column.
-
2
Open Data → Sort sheet or Data → Sort range.
-
3
Choose column and A→Z or Z→A.
-
4
Use Advanced options for multi-column sorts.
Related tutorials
These videos might help you go deeper on this topic.
How To Add Columns in Google Sheets
Related blog posts
Written guides that go deeper on this question.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “How to sort by multiple columns in Google Sheets” yet. Search Better Sheets on YouTube.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function ...
Open →SORT
SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort ran...
Open →#SPILL! error
#SPILL! means a dynamic array formula tried to fill multiple cells but something blocked the spill range. Another val...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →SORT()
Google Sheets SORT() function guide
Open →Related questions
How do you sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How do i sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to sort data on Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to sort columns in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.