Want to type a long text entry in Excel and prevent it from spilling over to blank cells to the right? You can use the Wrap Text check box in the Text Control section of the Alignment tab to have Excel create a multi-line entry in a cell. The program also automatically increases the height of its row if necessary to display all of the text. Get to the Alignment tab by clicking on a cell, and choosing Format, Cells
When you create multi-line text entries with the Wrap Text option, you can decide where each line breaks by inserting a new paragraph. To do this, put Excel in Edit mode by clicking the insertion point in the Formula bar at the place where a new line should start and press Alt+Enter. When you press the Enter key to return to Ready mode, Excel inserts an invisible paragraph marker at the insertion point that starts a new line both on the Formula bar and within the cell with the wrapped text.
If you ever want to remove the paragraph marker and rejoin the text split on different lines, click the insertion point at the beginning of the line that you want to join on the Formula bar and press the Backspace key.
Last updated: 2/22/07