Pivot table sorting is the set of controls that determine the order in which row (or column) items appear — by default alphabetical, but switchable to sort by the underlying values, by a custom sequence, or by manual placement of specific items regardless of their numbers.
Most people only ever discover the alphabetical option, because it’s the one Excel applies automatically the moment you drag a field into Rows. The sorting options that answer the questions a business actually asks — show me the top performers, order this by total value instead of name, keep one specific category locked at the top no matter what its number says — sit a click or two deeper, which is exactly why they get missed.
The Default Behavior and Why It Confuses People
Drag a field like Salesperson into Rows, and Excel sorts it A to Z without asking. That’s rarely the view anyone wants first. A sales manager cares who brought in the most revenue, not whose name happens to start with A.
Switching to value-based sorting takes only a few seconds once you know the click sequence — and that sequence is the first method below.
Method 1: Sort by Value Using the Field Dropdown
Click the dropdown arrow on your row field header inside the pivot table (this shows up as “Row Labels,” or as the specific field name if you’ve renamed it).
Choose Sort, and you’ll see Sort A to Z and Sort Z to A for alphabetical order, along with an option like “More Sort Options” for sorting by value.
Inside More Sort Options, select “Descending,” then pick your Values field — Total Sales, for instance — from the dropdown underneath, instead of leaving it set to sort by the row label text. Click OK.
The pivot table now reorders from highest value down to lowest, which lines up with what most people are actually trying to find: who or what performed best, not who comes first in the alphabet.
Method 2: The Faster Click-and-Sort Shortcut
Once a Values field already exists in your pivot table, there’s no need for the dialog box at all. Right-click directly on a number inside the Values column (an actual figure, not the field header), hover over Sort, and pick “Largest to Smallest” or “Smallest to Largest.”
The whole table reorders immediately based on that column, no dialog required. This is the method I reach for most during live analysis — fewer clicks, same result, once you know it’s there.
Method 3: Sorting When You Have Multiple Value Columns
With two or more fields sitting in the Values area — Total Sales alongside Total Units, say — right-clicking a number forces a choice of which column drives the sort, since Excel can’t guess whether you mean the sales figures or the unit counts.
Right-click a value inside the specific column you want to control the sort, and the sort applies based on that column’s numbers. The other value column simply rides along in whatever order results from the primary column you chose.
Method 4: Keeping a Specific Item Always at the Top Regardless of Value
Sometimes most rows should sort by value, but one row — a “Returns” line, an “Adjustments” category, or some reference row your business always wants visible first — needs to stay fixed at the top no matter what its number is.
There’s no built-in “pin to top” button for this, but a workaround handles it: click the row label cell and drag it to the top position by hand. Excel treats this as a manual placement, excludes it from later automatic sorts, and continues auto-sorting everything else around it.
This approach is somewhat fragile. Run a fresh sort through the dropdown menu later, and it can override your manual placement. Save this technique for a report that’s close to finished rather than one you’re still actively rebuilding.
Method 5: Sorting With Multiple Row Fields (Nested Sorting)
Put two fields in Rows at once — Region nested with Salesperson inside each region, for example — and sorting operates at each level on its own rather than as one flattened ranking.
Sort the outer field (Region) by value, and the regions reorder by their totals. Sort the inner field (Salesperson) by value with your cursor on a salesperson row, and the people reorder within their own region — but that reordering happens independently inside each group, not as one combined ranking spanning every region and salesperson together.
For hierarchical reports, this is typically the behavior you want: strongest region first, and within it, strongest performer first. It just tends to surprise anyone expecting one flat sort across every combination.
Method 6: Custom Manual Order (Not Alphabetical, Not by Value)
Some situations call for an order that’s neither alphabetical nor value-based — sorting months in calendar sequence, for instance, where alphabetical order would put “April” ahead of “January.”
If your date field is formatted as an actual date and grouped using the date grouping feature covered in an earlier tutorial, Excel displays months in correct calendar order on its own, since it’s reading the underlying chronological value rather than treating the month name as plain text.
For non-date custom orderings — a priority ranking of product categories that matches neither alphabetical nor numeric order — Excel offers custom lists (File, then Options, then Advanced, then Edit Custom Lists). Once you’ve defined one, a field can sort according to your own sequence instead of the standard choices. It’s a more advanced setup, one you won’t need often, but worth knowing exists for cases that call for it.
Showing Only the Top Items After Sorting
Sorting pairs naturally with filtering for a request that comes up constantly: show me only the top ten, ranked highest to lowest.
Sort by value first, then open the same Row Label dropdown, go to Value Filters, and select “Top 10.” Adjust the count away from the default ten if needed, and pick whether the ranking should be based on sum, average, or another calculation depending on what’s in your Values area.
Pair sorting with this Top filter, and you get the leaderboard view stakeholders tend to ask for — built entirely from native pivot table features, no separate ranking formula required.
A Quick Reference for Common Sorting Needs
| Business Need | Method |
|---|---|
| Highest value first, general case | Right-click a value, Sort, Largest to Smallest |
| Alphabetical order (rarely the actual need) | Field dropdown, Sort A to Z |
| Specific category pinned at top | Manually drag that row label to top |
| Months in calendar order | Ensure date field is grouped, not displayed as text |
| Custom non-alphabetical category order | Define a Custom List in Excel Options |
| Top 10 leaderboard view | Sort by value, then apply Top 10 Value Filter |
The Habit Worth Building
Before you hand a pivot table to anyone, check whether the current order answers the question they’re asking, or whether it’s just the default Excel applied when the field first landed in Rows. Alphabetical order rarely matches a genuine business priority, and the few seconds it takes to switch to a value-based sort is often the difference between a table someone has to scan for the answer and one that puts the answer right at the top.
What field are you trying to sort, and what’s off about it — wrong order, a category that won’t stay pinned, or something else? Describe your situation and I can point you to the exact method that solves it.