Column Width - Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2000. When I drag a field name from the Pivot Table toolbar to the "row" area of the Pivot Table, the resulting column width is often inadequate to display the contents. Of course, I am not prevented from widening the column after the fact; however, it should ideally provide a "best fit" width automatically.
Is there something I am missing here?
 
You can turn on the AutoFormat option, and the columns widths should adjust to fit:

Select a cell in the PivotTable
From the PivotTable toolbar, choose PivotTable>Table Options
Add a check mark to 'AutoFormat Table'
Click OK
 
Debra,

I checked the Table Options and autoformat IS checked, but the colums in the
"row" area still do not resize. Could it possibly have any relation to the
fact that this pivot table is using an OLAP file as its source?

Thanks, and have a great weekend
 
You must log in or register to reply here.

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
freeze width of a column used by pivot table 4
Column width of Pivot Table data goes back to default when data refreshed 2
Data display incomplete after creating Pivot Table 6
Pivot Table: Resulting Column Widths on Drill Down 0
Save new column width settings in pivot table 5
Pivot table column widths 1
Column Width Behavior 1

Back
Top