Enabling Automatic Column Width Adjustment
To enable the automatic adjustment of Excel column width to accommodate the contents of member and data cells:
- From the Oracle Smart View for Office ribbon, select Options.
- In Options, from the left panel, select Formatting.
- Select Adjust column width.
- Click OK.
- 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.