Pivot Table Column Widths

P

Patrick_KC

I have a pivot table that is part of a larger worksheet. when I choose
something new from the drop down box, the column widths expand to the full
width of the text instead of wrapping as I've formatted it to do. How can I
keep the columns from expanding and ruining the format of the report?
 
D

Debra Dalgleish

Set the pivot table to preserve formatting:

On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK
 
P

Patrick_KC

Debra,
Thanks for the tip, but that didn't work for some reason. I'm working on
Excel 2002. I deselected the Preserve Formatting and then selected it again,
but still didn't work. I changed the font size to 8 in the column headers
and wrapped the test, but again, when I selected a new option in the drop
down, the font went back to 10 and the text no longer wrapped.

Any other suggestions?
Thanks for your help.
 
D

Debra Dalgleish

Other things to try -- if they don't work, you could record a macro as
you refresh and reformat the pivot table. Then, run that when you want
to update.

--If possible, before formatting cells, set all page fields to (All).
--Before formatting cells, use the selection feature to cells.
(Depending on your version of Excel, you may also have to
enable selection. From the Pivot toolbar, choose PivotTable>Select,
and click on Enable Selection)
For example, move the pointer to the top of a column in the pivot table
(just above the column's heading cell). When the black arrow appears
(like the one that appears when the pointer is over a column button),
click to select the column in the pivot table. Then apply the formatting.
 
Top