Traditional Ways to Adjust Column Widths (Manually) In this example, Excel's default column width isn't wide enough to show all the text in column A.

However, if your data contains a dynamic array, this method won't work because Excel tables can't accommodate spilled arrays. Also, you might want to emphasize a different column.