How do I make a lot of text fit into one cell?

  • Thread starter Thread starter sjlaw85
  • Start date Start date
S

sjlaw85

I need to write a lot of information in one particular cell, I have wrapped
text so that it reads downwards, and this has worked thus far, however after
a certain point, no more text appears in the cell, even though it appears
when I click on the formula bar. I have tried autofit which does not remedy
the situation. I need to be able to see all of the text when it has printed
out.
 
To get all the text to appear in the cell as well as the formula bar, you
need to insert a hard return (ALT-ENTER) every so often.
 
There is an actual limit to what excel will display, even if you wrap
it, insert a hard return, etc. you need to use an additional cell.
 

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

Fitting text into a cell problem. Please help! 3
All Text Does Not Appear in Some Cells 2
How do I autofit row height to adjust to new text on Excel form? 1
Autofit text into a cell 1
Not all of the text is visible when looking at the cell. 5
How to unhide data in cells that have the text-wrap formatting app 3
Wrap text in merged cells VBA 2
Row Height - Forcing a Minimum ('03 & '07) 3

Back
Top