View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I place 3 lines of text (an address) in 1 cell?

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mark" wrote in message
...
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.