Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
tx_cowgirl
 
Posts: n/a
Default 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??
  #2   Report Post  
Posted to microsoft.public.excel.misc
ScottO
 
Posts: n/a
Default 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??


  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 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??



  #4   Report Post  
Posted to microsoft.public.excel.misc
tx_cowgirl
 
Posts: n/a
Default 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??

  #5   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 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...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
How do I get multiple lines of text in a Excel cell? Tene Excel Discussion (Misc queries) 10 September 9th 05 10:23 PM
Formula to lookup Multiple Column Text and then Count Result ShelbyMan Excel Worksheet Functions 2 August 22nd 05 01:43 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"