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.
- From the Smart View ribbon, select Options.
 - In Options, from the left panel, select Formatting.
 - Select the Adjust Column Width and Row Height check box.
 - Click OK.
 - 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.