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

Group By Half Years With Excel Pivot Tables  In our previous post, we were able to Group by Month using Pivot Tables.  Let us take it up another notch, and group it by Half Years!In the example below I show you how to get the Sales Grouped by Half Years: January to June and July to December DOWNL...
Show The Percent Of With Excel Pivot Tables  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation.It will display the value of one item (the Base Field) as the percentage of another item (the Base Item).This optio...
Pivot Table Styles The default Pivot Table style in Excel is very bland and boring, stemming from a lack of creativity from the nerds over at Microsoft!You can give some life to your Excel Pivot Table by simply changing the Pivot Table Style!For our example, this is our Pivot Table:...
Use An External Data Source To Import Data Into An... When creating an Excel Pivot Table, what happens if your data source is in another location?Would you have to copy your data into the same spreadsheet?Well, NO!  You can simply use the External Data Sources feature in your Pivot Table and Excel will magically import the d...