How to sort a pivot table manually in Excel

Click on a row or column label, hover over the cell's edge until the icon changes, then click and drag to where you want it to go.

How to sort a pivot table manually in Excel

Excel pivot tables tend to order column and row headings alphabetically (A-Z) or reverse alphabetically (Z-A). They can also be ordered easily by another field if you go into the table's settings. But what if you need to create a custom order?

This video shows how to sort an Excel pivot table manually to create whatever custom order you need:

  1. Click on a row or column label.
  2. Hover over its edge until the icon changes.
  3. Click and drag the label to wherever you need it to go.

Use Excel's manual sort method to go beyond typical A-Z and Z-A ordering. Sort your pivot table to create the custom sort order your need.

Practice data source: Top 5 U.S. agricultural export commodities by State (fiscal year), last updated 06/15/2022.