Wrap text in cell

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.
 
G

Gord Dibben

You can enter 32767 characters in a cell.

In Excel 2003 and earlier, only 1024 of these will be visible or printed.

I believe Excel 2007 will show 8192 characters.

If you add an Alt + Enter linefeed every 100 or so characters you can
increase this 1024 limit.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Why does my text in a cell with wrap text and auto height get cut 4
Change a great number of words in word files, with a macro as short as possible. 5
Cannot wrap text around an image 1
Wrapping and Anchors 0
Select Text to End of Footnote 9
Columns appearing from nowhere, formatting going weird 0
Why wont 'autofit' and 'wrap text' remain in tact? 3
Wrapping Text in Merged Cells 4

Top