Why does my text in a cell with wrap text and auto height get cut

  • Thread starter Thread starter HerbertB
  • Start date Start date
H

HerbertB

It seems that wrap text and autofit row width and row height have a limit.

Any idea where to change this limit?

I have quite a large text in a cell and when I do wrap text and autofit,
then parts of the text get cut of. The text is still there, but it is not
shown in the cell and it is cut off when printing.
 
HerbertB said:
It seems that wrap text and autofit row width and row height have a limit.

Any idea where to change this limit?

I have quite a large text in a cell and when I do wrap text and autofit,
then parts of the text get cut of. The text is still there, but it is not
shown in the cell and it is cut off when printing.
Click to expand...

From here:

http://office.microsoft.com/en-us/excel/hp051992911033.aspx


I found this:

Length of cell contents (text): 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.


Does this explain your problem?
 
Well, two ideas come to mind:

Break up your text into multiple cells with no more than 1,024 characters each.

Use Word for the text. Then insert the document into your worksheet as an object.
 
Back
Top