PivotTable Manual Sorting in Excel

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.