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