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 Oracle Smart View for Office 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.