How to sort a pivot table 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.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “How to sort a pivot table 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 →Pivot table
A pivot table summarizes a large table without writing SUMIFS for every combination. Drag fields into rows, columns, ...
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 →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 a table 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.