ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can I wrap text from one line to another? (https://www.excelbanter.com/excel-worksheet-functions/8033-how-can-i-wrap-text-one-line-another.html)

gabalex

how can I wrap text from one line to another?
 
this is in a comments section...

Frank Kabel

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

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




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" wrote:

Hi
but within a comment the text wraps automatically?

--
Regards
Frank Kabel
Frankfurt, Germany

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





Frank Kabel

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







Gord Dibben

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






gabalex

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







All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com