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.

Copying data from one Excel column to another often means an additional task; you must adjust the target column's width. Fortunately, there's an easy way to do so using Paste Special.

For Width, press W. Another way to adjust the height of an entire row in any version of Excel is topress Shift+Spacebar, and then press Shift+F10, which displays the Context menu (see screenshot at ...