Click the menu's "Column Width" option to open the Column Width dialog window. Type a width value in the "Column Width" text box and click "OK" to resize the columns.

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.

How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column.

Simply press CTRL and the numeric pad's + key—the non-Numpad + key won't work—to automatically resize all columns to fit the text contents.