Steve

Type a line then ALT + ENTER, type another line then ENTER.

ALT + ENTER is a carriage return in-cell.


Gord Dibben Excel MVP

On Tue, 17 May 2005 10:32:01 -0700, SteveB
wrote:

How do I enter two lines of text in a single row - w/o merging cells?
Ok if the text spreads across adjacent columns.
Currently, if I turn off wrap text, both lines stay on one line with a pipe
symbol. If I turn on wrap text, the text tries to wrap in the single cell.
I can't expand the cell to accomodate all the text.