Autofit doesn't work

[Guest]

Hello,

We created a chart in which one row contains text paste specialed from a web
site. We presume the paste special process should strip out any codes and
allow us to copy in just the plain text.

However, we cannot get autofit to work. After a certain number of lines,
the row no longer displays the rest of the text -- even though you can see it
if you click in the field and look in the formula box.

We've checked that there is no row height specified. We've checked Wrap
Text. We've selected autofit for both rows and columns.

Any ideas as to where the problem might be?

Many thanks,

 

[Gord Dibben]

Perhaps it quits appearing because you have reached the cell limit for
viewable/printable characters.

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, about every 100 characters..

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 or MS Word which is a word
processing application, unlike Excel which is not.


Gord Dibben Excel MVP

Hello,

We created a chart in which one row contains text paste specialed from a web
site. We presume the paste special process should strip out any codes and
allow us to copy in just the plain text.

However, we cannot get autofit to work. After a certain number of lines,
the row no longer displays the rest of the text -- even though you can see it
if you click in the field and look in the formula box.

We've checked that there is no row height specified. We've checked Wrap
Text. We've selected autofit for both rows and columns.

Any ideas as to where the problem might be?

Many thanks,

Gord Dibben MS Excel MVP