Pinterest Pixel

Sort an Item Row (Left to Right) With Excel Pivot Tables

I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that... read more

Download Excel Workbook
Bryan
Posted on

Overview

Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline

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:

Sort an Item Row (Left to Right) With Excel Pivot Tables

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

Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline

Download excel workbookSort-an-Item-Row-Left-to-Right.xlsx

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

Sort an Item Row (Left to Right) With Excel Pivot Tables

 

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.

Sort an Item Row (Left to Right) With Excel Pivot Tables

 

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.

Sort an Item Row (Left to Right) With Excel Pivot Tables

 

Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline

If you like this Excel tip, please share it
Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline
Sort an Item Row (Left to Right) With Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Group Periods In Microsoft Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...