Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how do I put multiple rows of text in one cell.
In other words, I need to be able to set a paragraph in one text box, but
cannot display it as one really long line. I need it to be multiple lines of text in one cell in other words. I have seen it done before. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how do I put multiple rows of text in one cell.
Separate the line with Alt-Enter.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "cbeatty551" wrote in message ... In other words, I need to be able to set a paragraph in one text box, but cannot display it as one really long line. I need it to be multiple lines of text in one cell in other words. I have seen it done before. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how do I put multiple rows of text in one cell.
Just press Alt+ENTER to break for a new line
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "cbeatty551" wrote: In other words, I need to be able to set a paragraph in one text box, but cannot display it as one really long line. I need it to be multiple lines of text in one cell in other words. I have seen it done before. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how do I put multiple rows of text in one cell.
make sure you format the cell for wrapping text
formatcellalignment Note if there are too many characters, excell will not format the excess (I think it is 256 but wont swear to it) and you will not be able to use text wrapping further in that Cell. a way to get around it is to put the information in a comment. I personally do not know of a limit for the formatting in a comment. "cbeatty551" wrote: In other words, I need to be able to set a paragraph in one text box, but cannot display it as one really long line. I need it to be multiple lines of text in one cell in other words. I have seen it done before. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open text file in excel that has multiple rows of data | Excel Discussion (Misc queries) | |||
How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) | |||
Excel will not show all text entered in a Cell merged from 9 rows | Excel Discussion (Misc queries) | |||
vlookup multiple text rows | Excel Discussion (Misc queries) |