how can I wrap text from one line to another?

[gabalex]

this is in a comments section...

 

[Frank Kabel]

Hi
but within a comment the text wraps automatically?

 

[gabalex]

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]

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

 

[Gord Dibben]

Within a cell you can "wrap text"(Format>Cells>Alignment) and autofit the
height(Format>Row>Autofit).

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

 

[gabalex]

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

gabalex