Limit to Wrapped Text?


L

Llobid

I have Excel 2003 and have created a worksheet form. That is, people can
open the file and type in the unprotected cells. In some cases, people
are needing to type multiple sentences ... therefore, I merged cells
together. Essentially I have merged 16 rows and 32 columns of cells to
create a "block" cell in which the user can type. I set the Alignment
attributes to "Wrap text" and "Merge cells".

The problem I'm having is that when the user reaches 12 lines of text,
the text stops wrapping and will not print. Everything wraps as it
should up until that point, but at the end of the 12th row, the text
trails off into the netherworld. Double-clicking the cell will bring
the text back and it appears to wrap normally, but when you click out
of the cell, it disappears again.

Any help would be appreciated.
 
Ad

Advertisements

D

Dave Peterson

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll be able to see more of that text.
 
L

Llobid

Thanks ... I did that, but the printed result is broken sentences tha
really doesn't look good. I'm wondering if there is some kind o
restriction built in to Excel that limits the number of words o
characters that will show when wrapped
 
D

Dave Peterson

Without adding those alt-enters, you'll be able to see about 1000 characters.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top