In Excel, if you select an entire worksheet you can then easily auto-size all the columns. However, when you create an Excel file in SAS Studio there doesn't appear to be any capability to re-size columns without defining each width manually.
If memory serves me right a previous update and release in SAS EG allowed this functionality by setting something within the ODS, but so far I have not found a solution for SAS Studio. Can anyone assist?