Home > Exploring Excel
Two Ways to Wrap Excel Text
"I am seeking to add a second row within a cell. I am having
trouble doing this. What procedure do I need to follow?" -- Patricia Z.
The common way to wrap text in Excel is with formatting. To do so,
select the cells you want to wrap. Press Ctrl+1 to display the Format
Cells dialog. In the Alignment tab, check the Wrap Text box. Then choose
If you prefer to use standard commands to access the dialog...
...in Excel 2003, choose Format, Cells.
...in Excel 2007 and above, choose Home, Alignment, Wrap Text.
Another way to wrap text is to insert a carriage return in the text,
forcing it to wrap in a cell. I frequently use this approach when I use
two lines of text when I'm setting up a column label.
To use this approach, type the text you want in the first line, press
Alt+Enter where you want the line break, then type the remaining text.
All the best,