View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.