Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I place 3 lines of text (an address) in 1 cell?
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I place 3 lines of text (an address) in 1 cell?
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 On Tue, 24 Oct 2006 09:33:01 -0700, Mark wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
How do I insert two lines of text into one cell? | Excel Discussion (Misc queries) | |||
place text in one cell | Excel Worksheet Functions | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |