Text is cut off even though wrap text is enabled.

G

Guest

Wrap text is enabled; autofit is enabled; I have expanded the cell height;
additional text is still cut off, both on screen & in printing.
 
R

Ron de Bruin

From the Excel help

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

Dave Peterson

If you sprinkle some alt-enters in your cell, you'll be able to see way more
than the 1000 characters.

But you may have to adjust the rowheight manually--once that string gets really
long.
 

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

Wrap text in cell 1
Why does my text in a cell with wrap text and auto height get cut 4
Merged cells/wrap text 1
Autofit cuts off part of text when printed 3
large text amount in cell will not display in the cell 3
Format cell to both Wrap text and shrink to fit 1
Row Height - Forcing a Minimum ('03 & '07) 3
Text in Cell -- Cut Off By Out Line of Cell 1

Top