Worksheet is cutting off portion of wrapped text, even when I use autofit. I
can manually expand each row, but should I have to?

I am looking for a solution to this problem also. I am entering long
text entries in a large cell with wrapping turned on. After X
charachters, the wrapping stops in the display and enlarging the cell
height does nothing to help the situation. I can enter hard line feeds
(alt+enter) at the end of each line, but that is a pain.
Any solutions or suggestions? The only other way around this is to use
a text box, but then again that is a pain.


--
drhayes
------------------------------------------------------------------------
drhayes's Profile: http://www.excelforum.com/member.php...o&userid=16330
View this thread: http://www.excelforum.com/showthread...hreadid=277157

Hi
do you use merged cells?

--
Regards
Frank Kabel
Frankfurt, Germany

"SeeFar" <(E-Mail Removed)> schrieb im Newsbeitrag
news:0D72A7AA-5D93-4011-862F-(E-Mail Removed)...
> Worksheet is cutting off portion of wrapped text, even when I use
autofit. I
> can manually expand each row, but should I have to?

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots.

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text.

Gord Dibben Excel MVP

On Wed, 10 Nov 2004 14:14:25 -0600, drhayes
<(E-Mail Removed)> wrote:

>
>I am looking for a solution to this problem also. I am entering long
>text entries in a large cell with wrapping turned on. After X
>charachters, the wrapping stops in the display and enlarging the cell
>height does nothing to help the situation. I can enter hard line feeds
>(alt+enter) at the end of each line, but that is a pain.
>Any solutions or suggestions? The only other way around this is to use
>a text box, but then again that is a pain.