Enabling Automatic Cell Width and Height Adjustment

You can enable the automatic adjustment of Excel column width and row height 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 the Adjust Column Width and Row Height check box.
4. Click OK.
5. From any ribbon, select Refresh to adjust columns in the current sheet.

If Adjust Column Width and Row Height is not selected, you can adjust the width of columns manually.