Default PivotTable category assignations

K

Kokomojo

I have dozens of fields to insert into a PivotTable. I love the fact that in
Excel 2007, I can simply check them off and they are inserted. My problem is
that many of my fields automatically go into the Row Labels and I would
prefer that they go into the Column Labels.

Is there any way to change the default way the PivotTable task pane assigns
fields to the different categories?

Thanks for any help.
 
Top