There are numerous ways to change column widths in Excel, but did you know you can force Excel to do this automatically when ...

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...