wrap text/row width adjusted - no text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello - My wrap text is checked, "general" allignment, and my row height is
fine, but part of the text in the cell wraps, except my 3rd paragraph -
doesn't wrap. I've tried everything.

Any suggestions?
Thanks, Julianne
 
Julianne

Possibly you have run up against a limitation of text length.

From Excel Help on "specifications" you will learn that you can enter 32767
characters in a cell but only 1024 of them 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
 

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

How do I autofit row height to adjust to new text on Excel form? 1
Wrap around setting won't adjust row hieght 3
Cells ignore Wrap Text formatting! 2
wrapped text in cells not displaying 2
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
wrap text 1
Wrapping text with line breaks problem 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3

Back
Top