You have your Pivot Table ready, all sorted nicely both from a row and column perspective.  However you just need that one minor sorting tweak or two.

Well, Excel seemingly has a lot of tricks and you can even sort an Excel Pivot Table manually!

For our example, let’s see this Pivot Table below.  It is sorted by years (2012-2014), and months (Jan-Dec).

But what if we want to move July to the top, and the year 2014 as the first column year?

Sort an Excel Pivot Table Manually

DOWNLOAD EXCEL WORKBOOK

STEP 1: To manually sort a row, click on the cell you want to move.  Hover over the border of that cell until you see the four arrows:

Sort an Excel Pivot Table Manually

 

Left mouse click, hold and drag it to the position you want (i.e. upwards to the first row)

Sort an Excel Pivot Table Manually

We dragged it to the top so it’s now the first row!

Sort an Excel Pivot Table Manually

 

STEP 2: To manually sort a column, click on the cell you want to move.  Hover over the border of that cell until you see the four arrows.

Left mouse click, hold and drag it to the position you want (i.e. all the way to the left)

Sort an Excel Pivot Table Manually

Voila! You have successfully manually sorted your Pivot Table!

Sort an Excel Pivot Table Manually

 

EXTRA TIP: You can click inside a cell e.g. January, and start typing in another month, like August.  This will also manually sort your Pivot Table items.

Helpful Resource:

Excel Pivot Table

 

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Move an Excel Pivot Table If you have your Excel Pivot Table ready, but it's not in the best location, how do you move this onto another section of your Excel worksheet? Well, you can simply select Move PivotTable and you can move your Excel Pivot Table very quickly! For our example, let's move this...
Group By Quarters and Years With Excel Pivot Table... Ever encountered needing a quick report of total sales numbers by each quarter, of each year? I was faced with this same scenario and looking at my data on hand, I only had sales numbers for each individual day. Grouping these would take a ton of effort & complex formul...
Clear & Delete Old Pivot Table Items Have you ever cleared, deleted or replaced your Pivot Table data/items but they still shows inside your Pivot Table filters? What gives?? Well, you can easily clear your Pivot Table's old items from your Pivot Table's memory or cache. In our example below we have our Piv...
Sort Largest to Smallest Grand Totals With Excel P...   I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort from largest to smallest with Grand Totals! Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period. Make sure to down...