fbpx
Yodalearning>Tutorials>How to sort in Pivot Table

Sorting data in alphabetical order is helpful when you have large amounts of data in a Pivot Table. Sorting lets you organize the data so it’s easier to find the items you want to analyze.

You can sort Pivot Table in Excel horizontally or vertically. This allows you to see, at a glance, the rows or columns containing the greatest or the smallest values.

The easiest way to sort a Pivot Table is to select a cell in the row or column that you want to order by and then select either Sort Ascending or Sort Descending, which are represented by the following symbols in the Excel menu:

Sort Pivot table to AZ Ascending and ZA Descending

Tips 1: When you sort data, be aware that:

ØSort orders vary by locale setting. Make sure that you have the proper locale setting in Regional Settings or Regional and Language Options in Control Panel on your computer.

ØData that has leading spaces will affect the sort results. For optimal results, remove any leading spaces before you sort the data.

ØYou can’t sort case-sensitive text entries.

ØYou can’t sort data by a specific format, like cell or font color, or by conditional formatting indicators, such as icon sets.

Now let’s go through the following steps to learn how to sort in in Pivot Table!


sort pivot table

Step 1: In this example, we have Pivot table which we want to sort in Ascending or Descending order. See above Picture. This table is showing monthly expenses based some category like Transport, Entertainment etc. We will ascending the category. Categories are decorated in the row serially as Transportation, Household, Grocery and Entertainment. We will sort these in ascending order. In Column Label click on AutoSort button.

Now click Sort A to Z

Step 2: Now click Sort A to Z.
the categories are decorated now as ascending order

Step 3: After do that the categories are decorated now as ascending order as like above picture.

let change Month as descending order on the left side column

Step 4: Now let change Month as descending order on the left side column. Click AutoSort button of Row Labels. And click Sort Z to A.

month is organized in Descending order

Step 5: Now month is organized in Descending order as like above picture.

let sort in the cost row from small amount to largest amount

Step 6: Now let sort in the cost row from small amount to largest amount. Click on cell B5 which contain 120. Now Click on Data tab and click Sort from Sort and Filter group.

Sort by value Dialog box will be appear

Step 7: Sort by value Dialog box will appear. Check Smallest to Largest and Left to Right. Click OK.

Now the cost is arranged in ascending way

Step 8: Now the cost is arranged in ascending way as like above picture.

Conclusion: Sort in pivot table is possible from A-Z Ascending & Z-A Descending Order.

Read More: How to Create Pivot Table in Excel