To wrap the text in cells automatically, perform the following easy steps:
- Select a single cell or a range of cells you want to enable word wrapping for. To select an entire worksheet, use the Ctrl+A key combination.
- Click the Wrap Text
icon located at the Home tab of the top toolbar. Once you click it, your text within the selected cells is wrapped to fit the column width. If you change the column width, data wrapping adjusts automatically.
Optionally, you might need to adjust the height of some rows. When you apply the Text Wrap option, the row height changes automatically to fit your multiline text. But in some cases the content of the cell is partially hidden. This can occur if you have previously set a custom height for this row. To make the cell data fully visible, you can perform the following steps:
- select the necessary row or several rows you want to adjust the height for,
- right-click the row heading,
- select the Set Row Height option from the contextual menu,
- click the Auto Fit Row Height option.
You can also set another height value using the Custom Row Height option.
If you need to switch off automatic text wrapping for some cells you have applied this option to, select the necessary cells and click the Wrap Text icon once again.
Sometimes you might also need to create a line break manually at an arbitrary point. To do that, position the insertion point within the text where you want to add a line break and press the Alt+Enter key combination to start a new line in the same cell. This can be done both within the cell and in the formula bar. To expand the formula bar use the arrow on the right.
That's all. Now you know how to wrap text in you spreadsheet cells.