Robert

Type the person's name then hold ALT key and hit <ENTER key.

Type next line then ALT + <ENTER again.

Type third line then hit just <ENTER key to leave the cell.


Gord Dibben Excel MVP


On Tue, 15 Mar 2005 05:15:05 -0800, Robert
wrote:

This doesn't seem to work for me....Am I missing something?

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.