By default, if the content of an Excel cell is too long fit in a cell, 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 two cases are shown below:
Therefore, you may sometimes want to wrap text in Excel cells, in order to fully display long text strings:
This is done by enabling the Excel Wrap Text option.
In order to wrap text in one or more cells, first select the cell(s) that you want to wrap, then enable the Wrap Text option for the selected cells using one of the following methods:
Click on the Wrap Text option, which is located in the 'Alignment' group of the Home tab of the Excel ribbon (see below).
The Wrap Text option can also be accessed via the 'Format Cells' dialog box. This method works in all versions of Excel, including older versions that do not have the Excel ribbon.
Open the 'Format Cells' dialog box by either:
Within the 'Format Cells' dialog box:
You can also cause the Wrap Text option to be enabled on by forcing a line break at a specific location 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 row 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.