How do I place 3 lines of text (an address) in 1 cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 24 Oct 2006 17:33 GMT

I want to place a 3 line address in one cell. Every time I try to press
"Enter" to go to the next line... it goes to the next cell. Please help.

Reply to this Message

Bernard Liengme - 24 Oct 2006 17:59 GMT

Before press down Enter, hold the ALT key down to insert a linefeed
character.
May need to format cell to allow word wrap.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I want to place a 3 line address in one cell. Every time I try to press
> "Enter" to go to the next line... it goes to the next cell. Please help.

Reply to this Message

Gord Dibben - 25 Oct 2006 00:46 GMT

Mark

Bernard has shown you how but do you really want to do this?

You can run into problems later when trying to sort by address numbers or street
names.

Also you may someday want to do a mailmerge for labels or such.

You should have each section in a separate cell.

Gord Dibben MS Excel MVP

>I want to place a 3 line address in one cell. Every time I try to press
>"Enter" to go to the next line... it goes to the next cell. Please help.

Reply to this Message