PivotTable Manual Sorting in Excel

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.

You’re not locked into the PivotTable sorting options provided by Microsoft.  Excel lets you arrange a PivotTable into any order you like.

Right-click on a PivotTable column and choose Sort | More Sort Options | Manual.

How to Drag and Sort

It’s not obvious how to select an item (row or column) to move it.

Hover your mouse over the line between cells until you get the ‘Hollow +’ mouse pointer.

Then click and drag to the new location.  A solid line is the guide to where the row/column will be placed.

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.