Sort Pivot Table headers

**Howardc1001** · 04-18-2020, 11:38 AM

Is there a way to sort the headers in a Pivot table in ascending order ? If so kindly let me know

**MarvinP** · 04-18-2020, 11:42 AM

Hi Howard,

You right click on the header in the pivot and select Sort in the dropdown. If you mean Column Headers you can select and drag them left or right. Watch this YouTube video. It shows all the other ways too.

https://www.youtube.com/watch?v=Sq9r1XZUMsA

**alansidman** · 04-18-2020, 11:42 AM

Not sure what you mean by headers, so take a look at Debra's page here on sorting and see if she has your answer.

https://www.contextures.com/excel-pi...e-sorting.html

**Howardc1001** · 04-18-2020, 12:34 PM

Thanks for the help

Sort Pivot Table headers

LinkBack

Thread Tools

Rate This Thread

Display

Sort Pivot Table headers

Re: Sort Pivot Table headers

Re: Sort Pivot Table headers

Re: Sort Pivot Table headers

Thread Information

Users Browsing this Thread

Similar Threads

Date format in pivot table headers

[SOLVED] Copy Pivot into Table - - headers going into Table body

[SOLVED] sort table data by selectable headers

[SOLVED] Database headers as Row objects in Pivot Table

Sort Excel 2010 Table by Headers

pivot table column headers

[SOLVED] Pivot table - colour of headers

Bookmarks

Bookmarks

Posting Permissions