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

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??

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

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

"tx_cowgirl" wrote in message
...
| 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??

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tx_cowgirl" wrote in message
...
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??

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

Thanks!! You both answered my question...

"tx_cowgirl" wrote:

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??

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

You're welcome (from us) !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tx_cowgirl" wrote in message
...
Thanks!! You both answered my question...