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.
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.
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.