how to sort multiple columns in excel pivot table

This option works differently in the Selected Columns pane than in other places, as described for Clear Sort.

Clear All Sorts in All Columns - Removes all sort specifications that you have made.

A sort that you specified in the view remains. If you make sort specifications in both the Selected Columns pane and in the view itself, then you return to the Selected Columns pane and click Clear Sort, only the sort that you specified in the Selected Columns pane is removed. Right-click the value to be sorted in the data and select the desired sorting command. This option works differently in the Selected Columns pane than in other places. Following are the steps used for sorting PivotTable data in Excel: First, create a Pivot Table based on data.

Clear Sort - Removes the sort specification for the specified column.

Add Descending Sort - Specifies that a descending sort for this column is added as another sort for the analysis.

Add Ascending Sort - Specifies that an ascending sort for this column is added as another sort for the analysis.

Sort Descending - Enables you to sort the values in the column by descending order, as a first-level sort.

For example, string values sort alphabetically A through Z, numbers sort lowest to highest, and dates sort earliest to latest.

Sort Ascending - Enables you to sort the values in the column by ascending order, as a first-level sort.

For example, when you sort a column, you can select from the following options: You can use many options to sort in views.

You can't sort values in ascending or descending order in any of the columns. In pivot table and trellis views, values in columns are sorted on an edge from left to right.

How to sort multiple columns in excel pivot table