Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to have multiple lines of text within one cell. I am not referring to
text wrapping. I want to press enter and go to another line of text. For example, I want a cell to look like this: 1. text text 2. text text 3. text text I know it can be done because I received a file that already had this. Unfortunately, I can't figure out how it was done. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Alt+Enter Should do it
"pluaggie" wrote: I want to have multiple lines of text within one cell. I am not referring to text wrapping. I want to press enter and go to another line of text. For example, I want a cell to look like this: 1. text text 2. text text 3. text text I know it can be done because I received a file that already had this. Unfortunately, I can't figure out how it was done. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Type your first line of text
Press Lefthand Alt and Enter together Type Your second line of text Press Lefthand Alt and Enter togther You get the picture??????? Regards Mike B -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "pluaggie" wrote: I want to have multiple lines of text within one cell. I am not referring to text wrapping. I want to press enter and go to another line of text. For example, I want a cell to look like this: 1. text text 2. text text 3. text text I know it can be done because I received a file that already had this. Unfortunately, I can't figure out how it was done. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Thanks Mike. I felt like an idiot, but I had to ask. "Mike" wrote: Alt+Enter Should do it "pluaggie" wrote: I want to have multiple lines of text within one cell. I am not referring to text wrapping. I want to press enter and go to another line of text. For example, I want a cell to look like this: 1. text text 2. text text 3. text text I know it can be done because I received a file that already had this. Unfortunately, I can't figure out how it was done. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
No problem. Your welcome.
"pluaggie" wrote: Thanks Mike. I felt like an idiot, but I had to ask. "Mike" wrote: Alt+Enter Should do it "pluaggie" wrote: I want to have multiple lines of text within one cell. I am not referring to text wrapping. I want to press enter and go to another line of text. For example, I want a cell to look like this: 1. text text 2. text text 3. text text I know it can be done because I received a file that already had this. Unfortunately, I can't figure out how it was done. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Lines of Text in One Cell | Excel Discussion (Misc queries) | |||
Multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
putting multiple lines of text in one cell | Excel Discussion (Misc queries) | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
Multiple lines of text in a cell | Excel Discussion (Misc queries) |