Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're welcome (from us) !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "tx_cowgirl" wrote in message ... Thanks!! You both answered my question... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) | |||
Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions |