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…

Sorting a Pivot Table | MyExcelOnline

DOWNLOAD WORKBOOK

STEP 1: You can sort by dragging the cell value

Sorting a Pivot Table | MyExcelOnline

This is now the sorted result:

Sorting a Pivot Table | MyExcelOnline

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 | MyExcelOnline

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

Sorting a Pivot Table | MyExcelOnline

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 | MyExcelOnline

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

Sorting a Pivot Table | MyExcelOnline

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

Sorting a Pivot Table | MyExcelOnline

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn