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

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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