autofit columns in pivot table

P

Pastel Hughes

I am using Excel 2002.
Whenever I change the order of the row items in the layout of a pivot table,
the column widths are inappropriate for the data that they contain,
and I must readjust them.
Is there not a way to ensure that this happens automatically?
 
D

Debra Dalgleish

You can try the AutoFormat option --

Right-click on a cell in the pivot table
Choose Table Options
Add a check mark to AutoFormat table
Click OK
 
P

Pastel Hughes

Unfortunately, there was already a check mark in the "Autoformat Table" box.
For some reason it doesn't seem to cover column-widths
 
Top