Colleen calls with a question today. She has a pivot table with too many fields in the Values area. She can't easily resequence them. Is there a way to see more fields in the Pivot Table Fields pane?
Table of Contents
(0:00) Areas Section Only
(0:12) Undock & Resize Field List
(0:22) Drag line between Fields & Areas
(0:29) Re-dock pivot table fields pane
(0:39) Dragging field headings in pivot table
(0:50) Rearrange by typing
Table of Contents
(0:00) Areas Section Only
(0:12) Undock & Resize Field List
(0:22) Drag line between Fields & Areas
(0:29) Re-dock pivot table fields pane
(0:39) Dragging field headings in pivot table
(0:50) Rearrange by typing
Transcript of the video:
We've got too many fields in the pivot table and it is tough to move them around. Open this little cog wheel here, go to Areas Section 2 by 2 and you get to see more of them. Easier to drag things around now.
To get even more space, click over here and undock just by tearing it off the left hand side.
Resize. Go back to the first selection.
And then you can have a line in between that you can drag.
And that gets you a lot more fields down here. Sometimes there's just too many fields and you won't be able to see them. Let's redock this.
We will very carefully drop it, right there. And then the alternate method.
Choose a field, go to the very bottom edge of that field.
You get the four headed arrow and you can just drag it in the pivot table.
You don't have to use the field list at all. If dragging fields is a drag, check this out: I want to move seven over to this column. I just Type 7 there and that 972 is going to move as soon as I press Enter. Amazing.
To get even more space, click over here and undock just by tearing it off the left hand side.
Resize. Go back to the first selection.
And then you can have a line in between that you can drag.
And that gets you a lot more fields down here. Sometimes there's just too many fields and you won't be able to see them. Let's redock this.
We will very carefully drop it, right there. And then the alternate method.
Choose a field, go to the very bottom edge of that field.
You get the four headed arrow and you can just drag it in the pivot table.
You don't have to use the field list at all. If dragging fields is a drag, check this out: I want to move seven over to this column. I just Type 7 there and that 972 is going to move as soon as I press Enter. Amazing.
