https://communities.sas.com/t5/SAS-Studio/Auto-re-size-column-widths-when-exporting-data-to-Excel/m-p/861368#M10833 <P>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.&nbsp;</P><P>&nbsp;</P><P>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?</P> Tue, 28 Feb 2023 13:41:29 GMT sasheadache 2023-02-28T13:41:29Z https://communities.sas.com/t5/SAS-Studio/Auto-re-size-column-widths-when-exporting-data-to-Excel/m-p/861368#M10833 <P>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.&nbsp;</P><P>&nbsp;</P><P>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?</P> Tue, 28 Feb 2023 13:41:29 GMT https://communities.sas.com/t5/SAS-Studio/Auto-re-size-column-widths-when-exporting-data-to-Excel/m-p/861368#M10833 sasheadache 2023-02-28T13:41:29Z