Pinterest Pixel

Sorting a Pivot Table

Sorting a Pivot Table There are a few ways that you can Sort a Pivot Table.  You... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Sorting a Pivot Table | MyExcelOnline Sorting a Pivot Table | MyExcelOnline

Sorting a Pivot Table

There are a few ways that you can Sort a Pivot Table.  You can Sort the Row/Column Labels as well as Values within a Pivot Table.  Below I show you three quick ways…

download workbookSort.xlsx

STEP 1: You can sort by dragging the cell value

Sorting a Pivot Table

This is now the sorted result:

Sorting a Pivot Table

STEP 2: You can also sort by typing an existing cell value

In our example, we are typing Widget Corp, which is currently located at the last row.

Sorting a Pivot Table

123 Warehousing gets pushed down, and Widget Corp moves to the top row.

Sorting a Pivot Table

STEP 3: You can also sort by right clicking.

Try it on any company name and select Sort > Sort A to Z

Our table will be sorted in alphabetical order based on the company name.

Sorting a Pivot Table

Try it also on the Grand Total column. Right click and select Sort > Sort Smallest to Largest

Sorting a Pivot Table

Our table is now sorted in ascending order by the Grand Total values!

See also  Rank Largest to Smallest With Excel Pivot Tables

Sorting a Pivot Table

 

If you like this Excel tip, please share it
Sorting a Pivot Table | MyExcelOnline Sorting a Pivot Table | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...