CR/LF in cells

[Maury]

Hello all.

I need to be able to put multiple lines of text with blank lines between
them into cells. I can do this by creating the data as I want it in a word
file then copy/paste into the cell, but I would like to be able to eliminate
this step and enter directly. When I enter the first line of data and hit
the return key, it goes to the next cell in the column. Any ideas? I figure
there has to be a way to turn it on since it is possible to paste the same
data in the cell.

Thanks in advance,

Maury

 

[Maury]

Found it. I swear, work on something all day, then figure it out right after
asking for help.

You hold hte 'alt' key while hitting the enter key.

Maury