How to Sort by Lables

Step 1: Click on a cell containing a pivot item you want to sort.

Step 2: Go to the “Data” tab in Excel.

Step 3: Select the Sort Option

Click either the “A-Z” button to sort items in ascending order or the “Z-A” button to sort items in descending order

How to Sort a Pivot Table in Excel

Excel is a powerful tool to store, organize, and visualize large volumes of data. A cell, a rectangular block is used to store each data unit. It can be used to visualize data using a graph plot or to get insights from data using formulas and functions. Generally, account professionals use this tool for financial accounting but everyone can use it according to their needs.

Similar Reads

How to Sort Pivot Table in Excel

A pivot table is a tool in Excel that allows users to aggregate data based on certain criteria to compare patterns and trends through the data in less time. Sorting the data in a Pivot table will make the data easy to analyze. Sorting can be done in multiple ways: Lowest to highest, Highest to lowest, or any other Custom order. Let’s see how to do pivot table sorting....

How to Sort the Data in Ascending Order

Perform the below steps to sort the pivot table in ascending order of “sum of amount” values(i.e. least amount should be at the top)....

How to Sort the Data in Descending Order

Follow the same steps to create a pivot table as mentioned above....

How to Custom Sort in a Pivot table

Follow the below steps to sort your data using custom sort....

Restrictions in Pivot Table Sorting

You can sort the data in the following ways:...

How to Sort by Lables

Step 1: Click on a cell containing a pivot item you want to sort....

How to Sort by Values

Sort Pivot Table Items by Values...

Also Read

How to Refresh a Pivot Table How to Remove Pivot Table But Keep Data in Excel Pivot Table Conditional Formatting in Excel...

FAQs

What is Autosort in Excel?...