Formatting multiple lines of text
Multiple lines of text can be entered into a single cell using automatic wrapping or manual line breaks. Each method is useful for different situations.
Using automatic wrapping
To set text to wrap at the end of the cell, right-click on the cell and select Format Cells (or choose Format > Cells from the menu bar, or press Ctrl+1). On the Alignment tab, under Properties, select Wrap text automatically.
Format Cells > Alignment dialog
The results are shown below.
Automatic text wrap
Using manual line breaks
To insert a manual line break while typing in a cell, press Ctrl+Enter. This method does not work with the cursor in the input line. When editing text, first double-click the cell, then single-click at the position where you want the line break.
When a manual line break is entered, the cell width does not change. The figure below shows the results of using two manual line breaks after the first line of text.
Cell with manual line breaks