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 or the Sort Descending button on the PivotTable list toolbar so that the button is not selected.