How to unwrap text in excel

To unwrap text in Excel, you need to disable the text wrapping feature. Text wrapping is used when a cell contains more text than its width, and Excel automatically moves the text to a new line within the same cell. Unwrapping restores the text to a single line.

Steps to unwrap text

1. Select the cell or range of cells that you want to unwrap.

2. Go to the Home tab on the ribbon.

3. In the Alignment group, find the Wrap Text button.

4. Click the Wrap Text button to turn it off. The text will now appear in a single line.

Adjusting column width

Unwrapping text may cause some text to be hidden if the column is too narrow. Adjust the column width as follows:

1. Hover the cursor over the right border of the column header.

2. Click and drag to increase the width manually.

3. Alternatively, double-click the right border to auto-fit the column to the text length.

Using Format Cells dialog

1. Select the cell or range.

2. Press Ctrl + 1 (Windows) or Command + 1 (Mac) to open the Format Cells dialog.

3. Go to the Alignment tab.

4. Uncheck the Wrap text checkbox.

5. Click OK.

Additional tips

• Unwrapping text may affect readability if the content is long. Consider using multiple columns or resizing cells for better visibility.

• Text wrapping and unwrapping do not affect the content of the cell; only the display changes.

This method works consistently on both Windows and Mac versions of Excel.