How to sort a pivot table
October 19, 2021
1,132
Views
0
1
1. Open a Spreadsheet with Pivot Table.
2. Place the cursor on the heading cell of the data we want to sort.
3. Then click the small drop-down button on the bottom right corner of the cell.
4. In the drop-down menu, we can select Ascending or Descending according to our needs.
This skill could also be used in Microsoft Office Excel and OpenOffice.
Was this helpful?
Trending Tutorials
- 1. Quickly locate the name of the row and column where the cell is located
- 2. How can we change the font in a cell
- 3. How can we use equation editor in WPS Writer
- 4. How to customize draw borders for tables
- 5. How to adjust line spacing in WPS Writer
- 6. Use COUNTIF function for conditional statistics