Pinterest Pixel

Sort an Excel Pivot Table Manually

You have your Pivot Table ready, all sorted nicely both from a row and column perspective.  However... read more

Download Excel Workbook
Bryan
Posted on

Overview

Sort an Excel Pivot Table Manually | MyExcelOnline Sort an Excel Pivot Table Manually | MyExcelOnline

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

Sort an Excel Pivot Table Manually | MyExcelOnline

Download excel workbookSort-a-Pivot-Table-Manually.xlsx

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.

See also  Show The Percent of Column Total With Excel Pivot Tables

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.

Further Learning:

If you like this Excel tip, please share it
Sort an Excel Pivot Table Manually | MyExcelOnline Sort an Excel Pivot Table Manually | MyExcelOnline

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...