Sort data in a field

Office PivotTable

Show All

Sort data in a field

Sort in ascending or descending order

Specify a custom sort order


  • 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.
  • To switch from ascending or descending sort to custom sort, click Sort Ascending or Sort Descending so that the button is not selected.