Changing the order of columns in a Pivot Table

[RaviWildcat]

Hi Everyone,

I'm extracting a table with items in various statuses - To Do, In Progress, Cancelled, Done. And, I'd like ot summarize in a pivot table.

However! The statuses by default are display alphabetically. So, the items are listed as Cancelled, Done, In Progress, To Do which looks silly.

I can preface the statuses with numbers (1. To Do, 2. In Progress 3. Done 4. Cancelled) but I'm simply to lazy to make those changes.

And! Most vexing of all! I'll bring those columns up in the rows section of the Pivot, highlight them and then click 'Move to The Top' or 'Move to Bottom' and sometimes that works but sometimes it doesn't!

I guess my real question is - what steps can I take to always be able to sort the columns / rows in my pivots?

 

[RoryA]

Unless you have another sort in place, you should always be able to drag them into the necessary order - subject to the usual rules of the sort only applying within any field to the left.

 

[BSALV]

Sort data using a custom list - Microsoft Support

Sort a list by days of the week or months of the year or sort by priorities in Excel. Or you can create your own custom list for items that don't sort well alphabetically.

support.microsoft.com

You can create you own "Custom Sort List" and use it then to sort your pivottable.
See link above, Your customlist would then be the one you wrote down there, without the numbers

 

[RaviWildcat]

Thanks Rory A - it works when I list them as columns but not rows for some reason

Thanks BSALV - I will try that!