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

Group Sales by Weeks With Excel Pivot Tables I am sure that your boss has asked you to come up with Total Sales numbers per week at least once in your current role!  If not, he will....very very soon! Now your data has only sales for each individual day, which makes you scramble to come up with a solution.   How will you...
Automatically Refresh a Pivot Table Have you had challenges with constantly Refreshing a Pivot Table? People forget that each time your data source gets updated that you will also need to manually Refresh your Pivot Table in order for it to get updated and show the changes made. A lot of people ask if there i...
Group By Custom Dates With Excel Pivot Tables In my previous Group By Month post, we grouped our Sales by each month. However the cool thing with Excel is that we can take that a step further and customize our grouped date range! In the example below I show you how to get the Sales Grouped by Custom Dates:   ...
Slicer Connection Option Greyed Out For Excel Pivo... Sometimes when you create a Pivot Table and want to insert a Slicer you are unable to do this as the Slicer button is greyed. You try to click on the Slicer button but nothing happens. What gives?? There are two things that can cause your Slicer connection to be grey...