A simple trick lets you copy source column's width to a target column in Excel. Refer to the steps in the post to copy column widths in Excel.

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.