## 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.

## Exercise files

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

Sorting Values.xlsx195.5 KB Sorting Values - Completed.xlsx

195.5 KB

## Quick reference

### Topic

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
- Change the manual sort to Ascending/Descending as appropriate
- Click the drop down and select the values field
- Click More Options…
- Re-check the AutoSort checkbox

Lesson notes are only available for subscribers.