How to Sort a Pivot Table in Excel (2026)
Sorting turns "list of things" into "ranked list of things" — the difference between a table and a report. This guide covers sorting by label, by value, by a specific column, and setting up custom sort orders.
⚡ Quick Answer
To sort by value: click the row-label dropdown → Sort → More Sort Options → Descending by → your value field. To sort alphabetically: same dropdown → Sort A to Z or Z to A.
Method 1: Sort by row label (alphabetical or chronological)
Click the row-label dropdown arrow
Small arrow at the top of the row-label column header.
Pick Sort A to Z or Sort Z to A
Alphabetical or reverse-alphabetical for text. Oldest-to-newest or newest-to-oldest for dates.
Fast and often good enough. But value-based sorting is usually more useful.
Method 2: Sort rows by value (best for rankings)
Click the row-label dropdown arrow
Same dropdown as above.
Pick "More Sort Options"
Sort dialog opens.
Select Descending (or Ascending) by
Radio button under "Sort options".
Choose the value field
Dropdown lists all Values in the pivot.
Click OK
Rows re-sorted by the chosen value.
Method 3: Sort by a specific column's values
Useful when your pivot has columns and you want to sort rows by one specific column.
Right-click any value cell in the target column
The column you want to sort by.
Sort → Sort Largest to Smallest (or Smallest to Largest)
Rows re-sort by that column's values.
Method 4: Manual custom sort
When natural sorting doesn't match your business order (e.g., you want "High Priority", "Medium", "Low" instead of alphabetical).
Click a row label
The one you want to move.
Drag to new position
Or right-click → Move → various options.
Excel remembers custom order
Persists through refresh, if manual sort is enabled in Field Settings.
Setting a custom sort list (reusable)
If you often need a specific order (like Q1, Q2, Q3, Q4 or Monday through Sunday), create a custom list.
File → Options → Advanced
Scroll to General section.
Edit Custom Lists
Dialog opens showing built-in and custom lists.
Enter your list
One value per line: Q1, Q2, Q3, Q4.
Click Add → OK → OK
List is now available across all workbooks.
How pivots use custom lists
Field Settings → Sort tab → tick "Use Custom Lists when sorting". Now when you sort A-Z, Excel checks your custom lists first for a matching order.
Sort options in Field Settings
Right-click any row label → Field Settings → click "More Sort Options" button:
- Manual (you can drag items) — custom drag-and-drop order
- Ascending (A to Z) by — alphabetical or by a value field
- Descending (Z to A) by — reverse alphabetical or descending value
Sorting nested pivots
When rows have nested fields (Region → State), sorting applies at each level. Example: Region sorts by descending revenue, then within each region, State sorts by descending revenue.
To sort just the outer level while keeping inner alphabetical, set each field's sort option in Field Settings independently.
Common sort problems
Cause: numbers stored as text in source data. Fix: source data → select column → Data → Text to Columns → General → Finish. This converts text-numbers to real numbers, and pivot sort works correctly.
Manual (drag) sorts sometimes reset. Field Settings → More Sort Options → set an automatic sort (by value) so refresh doesn't disturb it.
Field Settings → Sort tab → tick "Use Custom Lists when sorting". Otherwise Excel sorts strictly alphabetically.
Sort with slicers
When slicers filter the pivot to a subset, sort applies to the visible subset only. Change slicer selection, sort updates accordingly.
Ranked pivots in one prompt
Sorting a pivot means clicking through dialogs and remembering which value field to reference. Excel Wizard handles it in one line: "sort by descending revenue" or "rank products by margin then filter to top 10" — configures the pivot correctly.
Install Excel Wizard →Frequently asked questions
How do I sort a pivot table by value?
Click the row-label dropdown → Sort → More Sort Options → Descending by → pick your value field.
How do I do a custom sort in a pivot table?
Click and drag row labels to reorder manually. Or File → Options → Advanced → Edit Custom Lists to create a reusable custom sort order (like Q1-Q4).
Why won't my pivot table sort correctly?
Common causes: mixed data types in source (numbers as text); manual sort overriding automatic; or a custom list applying unexpectedly. Check Field Settings → Sort tab.
How do I sort by a specific column?
Right-click a value cell in the target column → Sort → Sort Largest to Smallest. Rows re-sort by that column's values.