Forum Discussion
Manually Sorting Pivot Table Columns
- 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.
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.
- Vidhi08Jan 02, 2020Copper Contributor
Thats perfect! I wouldnt know how to do it if not clearly mentioned here. SergeiBaklan
- Jon CohenOct 23, 2019Copper Contributor
SergeiBaklanRecently, I had problems with this. When I select the column to be moved, it wouldn't move.
The answer: Don't select the whole column. Instead, select only the cell containing the column title. Then moving the cursor to the left border changes the cursor to the "move" cursor. You can then drag it (horizontally) to the position you want.
- Sanket_PatoleOct 23, 2019Copper ContributorThank you Sergei, it worked.
- Jon CohenJun 11, 2018Copper Contributor
YES! That works. Thank you.