## About this lesson

Sorting the values area of a PivotTable.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

2016, **2019/365**.

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Sorting Values.xlsx199.1 KB Sorting Values - Completed.xlsx

199.4 KB

## Quick reference

### Sorting Values

Sorting the values area of a PivotTable.

### Where/when to use the technique

When you’d like to order the values in a PivotTable in order (either ascending or descending).

### Instructions

#### Sorting column values (including grand totals)

- Right-click a cell in the column you wish to sort by > Sort
- To have the largest numbers at the…
- Top: Choose Sort Largest to Smallest
- Bottom: Choose Sort Smallest to Largest

- The entire PivotTable value area will be re-sorted into the order of the selected column

#### Sorting grand total rows

- Right-click any value in the grand total row (except the bottom right cell) > Sort
- To have the largest numbers at the…
- Left: Choose Sort Largest to Smallest
- Right: Choose Sort Smallest to Largest

#### Sorting values from left to right

- Right-click a cell in the row you wish to sort by > Sort > More Sort Options
- Change the Sort direction to Left to Right
- To have the largest numbers at the…
- Left: Choose Sort Largest to Smallest
- Right: Choose Sort Smallest to Largest

#### Toggling automatic sorting

##### Turning off automatic sorting

- Right-click one of the row label fields > Sort > More Sort Options > More Options…
- Uncheck the AutoSort checkbox

##### Restoring automatic sorting

- Right-click one of the row label fields > Sort > More Sort Options
- Click More Options…
- Re-check the AutoSort checkbox
- Change the manual sort to Ascending/Descending as appropriate
- Click the drop down and select the values field

Lesson notes are only available for subscribers.