Two lines of characters in one cell

LindaM · Nov 1, 2004

After increasing the height of a row, how do I type two lines of text in one
cell,

Example: "Excess Wages
3rd Qtr."

Thank You in advance.
Linda

tjtjjtjt · Nov 1, 2004

Format|Cells. Check Wrap Text on the Alignment Tab.
Alternatively, you can press Alt+Enter to force a new line in a cell.

tj

Frank Kabel · Nov 1, 2004

Hi
use ALT+ENTER
to isnert manual linebreaks

Ron de Bruin · Nov 1, 2004

Hi Linda

Use Alt-Enter if you want to go to the next line in a cell

Dave Peterson · Nov 2, 2004

And if you ever need to do it with formulas:

=a1&char(10)&b1

(format|cells|alignment tab|check wordwrap)