In this example, Excel's default column width isn't wide enough to show all the text in column A. Excel offers two well-known ways to adjust your columns' widths .

Now, switch to the new Excel file in which you would like to retain the column width of the source file. Go to the File tab located on the Ribbon menu. Under it, click the Paste drop-down arrow.

If you want to base the columns on a fixed width, see the next section. 4. Click "Next." 5. Select one or more delimiters — in other words, what Excel should use to know how to separate the columns.