How do I define column width that allows multiple lines of text?

[Guest]

In Microsoft Excel, I am trying to set a column width. I want it to be so
that when I type something, it doesn't go ACROSS the page, but BELOW after a
certain length in the column. I want to be able to see all the information I
enter into the cell. (i.e. I want the cell to be able to take more than one
row worth of text - after it is entered, it goes down to the next line
instead of across or hidden.) How do I do this??

 

[ScottO]

Select the range of cells you want, then go Format>Cells>Alignment
Tab and click the Wrap Text check box.
If you want to force a line feed in your text, hit alt+enter.
Rgds,
ScottO

| In Microsoft Excel, I am trying to set a column width. I want it
to be so
| that when I type something, it doesn't go ACROSS the page, but
BELOW after a
| certain length in the column. I want to be able to see all the
information I
| enter into the cell. (i.e. I want the cell to be able to take more
than one
| row worth of text - after it is entered, it goes down to the next
line
| instead of across or hidden.) How do I do this??

 

[Max]

Press Alt+Enter to break for a new line within a cell
(doing this will auto-set the cell to "wrap text")

To wrap text in an entire col, select the col
Click Format > Cells > Alignment tab
Check "Wrap text" > OK

 

[Guest]

Thanks!! You both answered my question...

 

[Max]

You're welcome (from us) !