ADVERTISEMENT

Excel: Sort pivot table results in Excel 2003/XP/2000/97

---

Also learn how to sort pivot table results in Excel 2007.

Question:  How do I sort the pivot table results in Excel 2003/XP/2000/97?

Answer:  Select the row heading that you wish to sort on. Right-click and then select "Field Settings" from the popup menu. In this example, we've selected the row heading called Order ID.

When the PivotTable Field window appears, click on the Advanced button.

Under the AutoSort options, select either Ascending or Descending depending on the sort order that you wish to select. Click on the OK button. In this case, we've chosen to sort the Order ID field in ascending order.

This will return you to the PivotTable Field window. Click on the OK button.