wrapping text from one row to the next

[blazon]

How do I wrap text from one row to the next? I'd like any text that extends past column AE (written in column A) to automatically wrap to the next row.

Thanks so much!

[swatsp0p]

When you say next "row", do you mean the next cell down -- or -- to wrap to the next 'line' within the same cell?

[blazon]

Next row (sorry for not being clear)

[swatsp0p]

I don't know of any way to automatically force text to the next cell down based on which column it appears to reach. It is still all in cell A1. How wide are your columns? If you make them wider, you'll have more room to not overlap AE (column 31). Also, if you have any kind of entry in any cell from B1:AD1, your text will not be visible beyond that particular cell.

Check out "merge cells" and "text wrap" in Format>Cells|Alignment to see if that may meet your needs.

I don't understand why you want to put your extended in text in cell A2. Maybe someone else has a better grasp of what you are trying to accomplish.

Sorry.

[ssc1280]

You can use "Edit", "Fill", "Justify" to accomplish what you want, but its a
manual procedure.

"swatsp0p" wrote:

>
> I don't know of any way to automatically force text to the next cell
> down based on which column it appears to reach. It is still all in
> cell A1. How wide are your columns? If you make them wider, you'll
> have more room to not overlap AE (column 31). Also, if you have any
> kind of entry in any cell from B1:AD1, your text will not be visible
> beyond that particular cell.
>
> Check out "merge cells" and "text wrap" in Format>Cells|Alignment to
> see if that may meet your needs.
>
> I don't understand why you want to put your extended in text in cell
> A2. Maybe someone else has a better grasp of what you are trying to
> accomplish.
>
> Sorry.
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=469938
>
>