In Excel, how do I put multiple rows of text in one cell.

G

Guest

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.
 
B

Bob Phillips

Separate the line with Alt-Enter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
G

Guest

make sure you format the cell for wrapping text
format>cell>alignment

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple lines of text in a cell 3
Wrapping text with line breaks problem 1
Pulling Multiple Text Strings in a One Cell 4
Multiple lines of text within one cell 4
How do I put a "hard space" into text in a excel 2007 cell? 2
Multiple Lines of Text in One Cell 1
Text Running Out of Cell 1
wrap text multiple column with format 1

Top