How do I set text to fit columns?

T

Tim B.

I've searched the forums, but I am just having a bit of trouble asking what I
want to do. (I don't use Excel as much as Word, so I'm a bit rusty.)

I'm creating an informational spreadsheet whose cells are full of a lot of
wordly information that should be broken onto multiple lines to be able to
fit into the confines of the column I've sized for it. I can drag each cell
down to have more width, but I cannot figure out how to make the text fill up
the newly fattened cell; that is, to have several line breaks instead of just
neverending text on one line. I know it's possible (or, I think I know) but
I forget how it's done. Any suggestions?

I really appreciate it.

-Tim
 
P

Paul B

Tim, to get a new line within a cell use Alt+enter

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
T

Tim B.

Thanks Paul and Ron!

I also was poking around in the cell settings and turned on Word Wrap, which
has done most of the work for me. I can't believe I didn't think of that.

Tim
 
Top