Wrap Text in Excel

Sometimes, you may want to wrap text in Excel cells, in order to improve the appearance of, or easily view long text strings.

If the wrap text option is not enabled and the contents of an Excel cell are too long to be displayed, one of two things will happen. Either the text string will be displayed over the top of the adjacent cells, or, if the adjacent cells contain values, the displayed text will be cut off at the cell boundary.

These cases are shown in cells A1-A2 of the spreadsheet below, while cell A3 shows the same text string with the wrap text option enabled.

Example of Wrap Text in Excel

Switching on the Wrap Text Option

Method 1:

Excel Wrap Text Option Button

Method 2:

If you have an older version of Excel, which does not have the ribbon options, you can switch on the Wrap Text option as follows:

Excel Wrap Text Option

Forcing Line Breaks

You can also cause the Wrap Text option to be enabled on by forcing a line break in an Excel cell.

To do this:

Enter Line Break in Excel Formula Bar

Resizing Cells with Wrapped Text

If you wrap text in a single Excel cell, depending on your settings, the height of the cell may or may not automatically adjust, to show the whole of the wrapped text.

Automatically Adjust Row Height in Excel

If the cell height does not automatically adjust, you can force it to do this by double clicking on the row labels at the left hand side of the spreadsheet.

For example, to auto-adjust the height of row 1, double click on the line between rows 1 and 2 of the spreadsheet, in the grey label area at the left of the spreadsheet.

Resizing Merged Cells with Wrapped Text

Note that the auto-sizing of cells does not work with merged cells. If you have wrapped text in a merged cell, you will need to resize the cell manually, by dragging the bar between the row labels to the desired height.