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 below so that we will have the same starting point, we want to sort the table by the values in the April row from Smallest to Largest:

In the example below I show you how to Sort an Item Row from Left to Right:


STEP 1: Right click on a Sales Number in the April row.  Go to  Sort > More Sort Options


STEP 2: Make sure the following are selected: Smallest to Largest, Left to Right.

You can see in the summary that it will sort in ascending order using the values in the April row.

Click OK.


STEP 3: This will sort our sales numbers from left to right using the values in the April row.

See that our years are now arranged in this order: 2014, 2012, 2013.


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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show & Hide Field List in Excel Pivot Table Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears?Lots of Excel users get annoyed with this but luckily I'm here to help you out 🙂If your Pivot Table Field List disappears, you can easily bring it back as I show you be...
Frequency Distribution with Excel Pivot Tables With Excel Pivot Tables you can do a lot of stuff with your data! But did you know that you can even create a Frequency Distribution Table?Let's have some fun below! I'll show you how easy it is to create your own Frequency Distribution Chart!We will create a chart based ...
Sort an Excel Pivot Table Manually 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 t...
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...