Automatic continuation to another cell

Is there a way to have excel automatically continue to a second or subsequent cells when the text being typed in it fills the cell?

Hi BigChuckMeister

By default Excel will overflow to the next cell, if it is empty. See samples attached.

Regards
Alastair

I thank you for your time and assistance, however, this doe not resolve my issue. What I am trying to accomplish could be considered to be more like a newspaper article which begins on the front page, but, is continued in another section altogether. Again, thank you for all of your time.

Hi BigChuckMeister

In any given cell you can have 32,767 characters. All you need to do is to type in what you want and then make the cell bid enough to contain the text. Then move on to the next section and repeat. Or am I missing something here?

Perhaps if you showed me an example?

Regards
Alastair

Sorry I didn't reply sooner. Again, thank you for the response. According to what I'm seeing I will assume that what I am asking about cannot be done. All of the suggestions posted are the straight-forward sort of things that I already know. However, in one last attempt, I will describe the form (since I cannot upload it)

Standard paper with .25 margins all the way around, columns set at 9.57 width - I believe that means the document goes through column "L" if I remember correctly.

The first seven rows (approximately) from the top are our company heading, and cells set up as fill in the blanks for specific job information and personnel information.

Then there are twenty rows that are joined as follows:

columns A:C = one column
columns D:G = one column
columns H:L = one column
Note: none of the rows are adjoined - only the columns, in order to make the columns wider.

Row 28 through the end of the page are a different section similar to the first seven rows mentioned above. I need to be able to type text in the first row of H:L that will Cary down through the cells to the end of the page without changing the size of The cells or having the text too small too read (shrink to fit) or overlapping another cell. This document is a form and needs to maintain its original appearance. If all of the rows in column H:L becomes full on the first page, I need it to continue to a second and possibly third or fourth page. Again, without adjusting the cells since this document is considered a company form and may need to be used legal proceedings (hopefully not, but, always a possibility).

Thank you so much for your time and assistance.

Hi BigChuckMeister

I hope that I have interpreted your explanation correctly.

I cannot do an automatic jump to the next page, bu can do a free text box where the operator has to take control. Depending on who the operator is, this is probably not acceptable.

I think that I may have to chalk this up as a fail

Straw clutching:
1. Depending on what is in the "Lower part of page" - could this be the footer ?
2. redesign the form
3. Use MS Word with text boxes for "Lower part of page"

Regards
Alastair

Thank you. And just out of curiosity, since I'm so
New at this, what exactly do ordinary people get out of this? Helping complete strangers figure out their excel problems, for free.

Regardless, thanks.

Well, thank you very much - to all of you.

Chess is boring (and I usually lose), I've written a program (in Excel) to solve Sudoku, I can't spell - so crosswords are out and the medical man has banned me from drinking. What else can I do in the evening?

Regards
Alastair