Sort data in a PivotTable list

Office PivotTable

Show All Show All

Sort data in a PivotTable list

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Do one of the following:

    ShowSort in ascending or descending order

    ShowSpecify a custom sort order

Notes

  • To switch from ascending or descending sort to custom sort, click Sort Ascending Button image or Sort Descending Button image so that the button is not selected.
  • The order in which numbers, text, and special characters are sorted depends on the source data and your regional settings in Microsoft Windows Control Panel. If users have different regional settings in their browsers, their sort orders might be different from yours.