There are numerous ways to change column widths in Excel ... and right-click the sheet tab at the bottom of the Excel window. Then, click "View Code." In the VBA window, select "Worksheet ...

and choose AutoFit Column Width (Figure B). Figure B Either way, Excel expands the width to accommodate the longest entry in the column, as shown in Figure C. Excel enlarges the width of the column.