autofit columns in pivot table
 

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?

autofit columns in pivot table
 

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

Pastel Hughes wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

autofit columns in pivot table
 

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

"Debra Dalgleish" wrote:

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

Pastel Hughes wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html