O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sorting and Filtering a PivotTable

To make a PivotTable show the data you require, you may need to sort it or filter it.

To sort a PivotTable, click the pop-up button of the field by which you want to sort. Excel displays the sorting and filtering window for that field. The window bears the field's name, as you can see in Figure 12–19, which shows the sorting and filtering window for the Product field. You can then click the Ascending button to produce an ascending sort (from A to Z, from small numbers to large numbers, and from early dates and times to later ones) or the Descending button to produce a descending sort (the opposite).

images

Figure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required