Remove sort order

Office PivotTable

Remove sort order

Removing ascending or descending sort order will return the data either to its natural order, or if a custom order was specified, to the custom order.

  • Click the Sort Ascending button Button image or the Sort Descending button Button image on the toolbar so that the button is not selected.