Skip to content

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.

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.