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 WORKBOOK

Sort

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

Share on Google+

Related Posts

Sort an Item Row (Left to Right) With Excel Pivot ... I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort any row from left to right!!Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period.Make sure to download the Excel Workbook b...
Add Columns to Pivot Table Slicer Buttons When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.Say that your Pivot Table Slicer is showing months from January to December.  You can change the layout of the buttons to show in 3 separate column...
Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac.They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...
Sort Field List In a Pivot Table from A to Z Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List?Well you can save time by sorting the Pivot Table Field List in alphabetical order!To do this you need to Right Click...