Column Width Behavior

G

Guest

I use pivot tables alot - and I am working with a pivot table where I've set
the column width to 9. When I pivot new information in, the column width
automatically adjusts to fit, then I have to go and reset the columns back to
9.

Is there anyway to override this "adust to fit" behavior and just let the
pivot table fit as much text as it can into the column width I specify?
 
G

Guest

Kirk,
Unselect the 'Autoformat Table' option in the Options section of the Pivot
Table.
HTH,
Gary Brown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables and column widths 1
Column width format 2
Column width of Pivot Table data goes back to default when data refreshed 2
Save new column width settings in pivot table 5
Column Width - Pivot Table 2
column width in autoformatted pivot table 5
freeze width of a column used by pivot table 4
Pivot table column widths 1

Top