Excel doesn't know how much text is in cell until you hit Enter or Tab or
arrow out of the cell.

Also Excel doesn't know where you last row is unless you somehow tell it.

To do what you want would require VBA and more details.

But I am happy to hear you have figured out "everything else" about Excel
2003

That is quite an accomplishment.


Gord Dibben MS Excel MVP

On Fri, 23 Jan 2009 07:02:09 -0800, Ken "Bulldawg" Busler <Ken "Bulldawg"
Busler @discussions.microsoft.com wrote:

I have Excel 2003 and I have figured everything else out except for how to
carry text over to the next row when I reach the end of the previous row. And
at the end of the last row, I'd like to have it automatically go to the
second page onto a specific line. Thanks.