MS Excel: Sort pivot table results in Excel 2011 for Mac
Also learn how to sort pivot table results in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.
Question: How do I sort the pivot table results in Excel 2011 for Mac?
Answer: To sort the pivot table, let's take a look at an example.
Currently the pivot table is sorted by Order ID in descending order. We would like to sort by the Order ID values in ascending order.
Click on the arrow to the right of the Order ID drop down box and click on the Ascending button. Then click on the X in the top left to close the Order ID window.
Now when you view the pivot table, the Order ID values are sorted in ascending order.
