Forum Discussion
Solved
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 different types in a specific (non-alphabetical) order.
I can click on the down arrow on the "Column Labels" field, and select "More Sort Options". In the pop-up window ("Sort Options"), I can put a check in the "Manual (you can drag & drop items to rearrange them)" box.
And after that, I'm stumped. I can't drag the column labels on the pivot table. I can't drag on the list that shows up when I used the Column Labels down arrow. I can't drag the whole columns What am I supposed to be able to drag & drop?
Thanks in advance.
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.
Hi Jon,
You may manually drag entire column in Pivot Table like this
Sorry, but that's not working for me. I can highlight the pivot table column easily enough -- I move the cursor to the top of the column header/title until it turns into a dark down arrow. Clicking then highlights the entire pivot table column.
But then, how do I drag it? If I drag the down arrow, it highlights the next column, too, without changing the order of the columns. If I click in the column somewhere, the cell I highlighted gets selected. I can highlight the entire column like normal, but I can't drag it anywhere. What do I click on to drag the column?
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.
