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.
Click on the Wrap Text option, which is located in the 'Alignment' group of the Home tab of the Excel ribbon (see right above).
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:
You can also cause the Wrap Text option to be enabled on by forcing a line break in an Excel cell.
To do this:
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.
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.
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.