Forum Discussion
Jon Cohen
Jun 05, 2018Copper Contributor
Manually Sorting Pivot Table Columns
I have a simple pivot table -- it looks great & is a great help. I have only one field in Columns, called "Type", and there are six different types (therefore, six columns). I want to sort those di...
- Jun 11, 2018
Hi Jon,
After you selected the column point mouse on the border of that column catching the moment when the pointer becomes the "move pointer", click on it then and drag the column. That is described here https://support.office.com/en-us/article/move-or-copy-cells-rows-and-columns-3ebbcafd-8566-42d8-8023-a2ec62746cfc, with Pivot Table it works exactly the same way.
SergeiBaklan
Jun 11, 2018Diamond Contributor
Hi Jon,
After you selected the column point mouse on the border of that column catching the moment when the pointer becomes the "move pointer", click on it then and drag the column. That is described here https://support.office.com/en-us/article/move-or-copy-cells-rows-and-columns-3ebbcafd-8566-42d8-8023-a2ec62746cfc, with Pivot Table it works exactly the same way.
Sanket_Patole
Oct 23, 2019Copper Contributor
Thank you Sergei, it worked.