Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gabalex
 
Posts: n/a
Default how can I wrap text from one line to another?

this is in a comments section...
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

gabalex wrote:
this is in a comments section...



  #3   Report Post  
gabalex
 
Posts: n/a
Default

I'm sorry, I didn't phrase that the best. Say you have a comment section
looking like this:
_________________
_________________
_________________

and you want to set it up so that if you start typing on line one but run
into the edge of the line it will wrap to the next one, how would you do
that, if it is even possible. I hope that explained it better:) Thank you
again.

"Frank Kabel" wrote:

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

gabalex wrote:
this is in a comments section...




  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
'Format - Cells - alignment' and check 'wrap text'

--
Regards
Frank Kabel
Frankfurt, Germany
"gabalex" schrieb im Newsbeitrag
...
I'm sorry, I didn't phrase that the best. Say you have a comment section
looking like this:
_________________
_________________
_________________

and you want to set it up so that if you start typing on line one but run
into the edge of the line it will wrap to the next one, how would you do
that, if it is even possible. I hope that explained it better:) Thank
you
again.

"Frank Kabel" wrote:

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

gabalex wrote:
this is in a comments section...






  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

Within a cell you can "wrap text"(FormatCellsAlignment) and autofit the
height(FormatRowAutofit).

Also, within a cell, you can force a new line by hitting ALT + ENTER.

You cannot make Excel drop to the next row(cell) automatically, if that's what
you want.

Gord Dibben Excel MVP

On Thu, 16 Dec 2004 13:39:03 -0800, "gabalex"
wrote:

I'm sorry, I didn't phrase that the best. Say you have a comment section
looking like this:
_________________
_________________
_________________

and you want to set it up so that if you start typing on line one but run
into the edge of the line it will wrap to the next one, how would you do
that, if it is even possible. I hope that explained it better:) Thank you
again.

"Frank Kabel" wrote:

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

gabalex wrote:
this is in a comments section...







  #6   Report Post  
gabalex
 
Posts: n/a
Default

Thank you , I didn't think so, but wanted to make sure I wasn't
mis-remembering information.

gabalex

"Gord Dibben" wrote:

Within a cell you can "wrap text"(FormatCellsAlignment) and autofit the
height(FormatRowAutofit).

Also, within a cell, you can force a new line by hitting ALT + ENTER.

You cannot make Excel drop to the next row(cell) automatically, if that's what
you want.

Gord Dibben Excel MVP

On Thu, 16 Dec 2004 13:39:03 -0800, "gabalex"
wrote:

I'm sorry, I didn't phrase that the best. Say you have a comment section
looking like this:
_________________
_________________
_________________

and you want to set it up so that if you start typing on line one but run
into the edge of the line it will wrap to the next one, how would you do
that, if it is even possible. I hope that explained it better:) Thank you
again.

"Frank Kabel" wrote:

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

gabalex wrote:
this is in a comments section...





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
In Excel, using line wrap with text, some cells will appear as ##. RSCoyner Excel Discussion (Misc queries) 4 January 19th 05 11:21 PM
Concatenation formula loses text wrap formatting DFM Excel Discussion (Misc queries) 5 December 27th 04 01:45 PM
Why text to columns is not available when there is mulipule line . Bing Excel Worksheet Functions 1 December 8th 04 05:14 AM
Adding a text label to a line. Neil Charts and Charting in Excel 1 December 4th 04 08:41 PM
Forcing text onto new line in cell Doug Poll New Users to Excel 2 December 3rd 04 12:09 PM


All times are GMT +1. The time now is 05:59 AM.

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"