Wrap Text Help Needed!

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

Guest

Hello,

My problem is that I have a large amount of text in one cell. I've clicked
on the wrap text box and have tried the format/row/auto fit selection also.
Not all of my text is being displayed or when I try to print . Any ideas???

Thanks
 
This is a well-known problem (Excel's not yours). The text is actually
there, it just doesn't show. To fix the problem, insert a hard return every
1000 characters or so.


Use ALT-ENTER as the hard return
 
There is a limit to what can be type in a cell, and a limit to what will be
displayed.

Cell limits are:

32,767 characters maximum.
Only 1,024 display in a cell
All 32,767 display in the formula bar.
 
If you add alt-enters to force a new line every 80-100 characters, you can see
more.
 
You must log in or register to reply here.

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

wrapping text in merged cells 2
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
Cells ignore Wrap Text formatting! 2
Merged cell text does not wrap 1
Excel 2007 Adds Spaces when Wrap Text is Used 3
Merged cells stop wrapping 4
wrap text 1
Cannot save text wrapping in cells-must do individually 1

Back
Top