Controlling column width for new pivot tables

  1. From the menus choose:

    Edit > Options...

  2. Click the Pivot Tables tab.
  3. Select the option you want for Column Widths.
  4. Click OK or Apply.
  • Adjust for labels and data except for extremely large tables. For tables that don't exceed 10,000 cells, adjusts column width to whichever is larger—the column label or the largest data value. For tables with more than 10,000 cells, adjusts column width to the width of the column label.
  • Adjust for labels only. Adjusts column width to the width of the column label. This produces more compact tables, but data values wider than the label may be truncated.
  • Adjust for labels and data. Adjusts column width to whichever is larger: the column label or the largest data value. This produces wider tables, but it ensures that all values will be displayed.