How to sort in Pivot Table | Custom Sorting

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

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 be 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

Related Tutorials

Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018
Excel Quartile Function in Excel
May 8, 2018
How to use the Excel PERCENTILE function
May 7, 2018
Insert or Type degree symbol in Excel with Autocorrect Feature
May 7, 2018
25% Discount
No prize
All Courses at $200
Almost!
10% Discount
Free Ebook
No Prize
No luck today
Almost!
50% Discount
No prize
80% Discount
Get a chance to boost your knowledge!
Use this coupon code for any course that you wish for. 
Our in-house rules:
  • You can choose any course & redeem coupon
  • If you find any difficulty, mail us on [email protected]
  • Wheel Spin will end soon
  • Coupon code can be applied within 2 days.