Enabling Automatic Column Width Adjustment

  To enable the automatic adjustment of Excel column width to accommodate the contents of member and data cells:

  1. From the Smart View ribbon, select Options.

  2. In Options, from the left panel, select Formatting.

  3. Select Adjust column width.

  4. Click OK.

  5. From any ribbon, select Refresh to adjust columns in the current grid.

If Adjust column width is not selected, you can adjust the width of columns manually.