How do I show all the contents of a cell?

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

Guest

I have a cell that has possibly thousands of characters. I've merged it with
about twenty other cells, but even though there is more than enough room to
spare, it still truncates my text at a given point. I've tried every setting
I know how, but it won't show the rest of my text. I can't add a textbox or
something like that (this is not my spreadsheet). Anybody have a suggestion?
Thanks.
 
1. Never use merged cells, it will usually create problems.
2. A cell can display up to 1024 characters (it can be overcome somewhat by
using a lot of alt + enter in the cell but not that many more), regardles if
you merge 200 cells that won't change.. What's in merged cells will always be
the uppermost left cell within the merged range. So use one cell only and
between each line put alt + enter, that way you might get some more
characters


Regards,

Peo Sjoblom
 
Hello-

Maybe this will help:

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

Good Luck|:>)
 
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

How do I stop cell contents from spilling into the next cell? 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I increase viewable cell character count limit in Excel? 2
display content of merged cells 1
Link a textbox on a sheet to a cell?! 2
How do I show all words in a cell? 4
Cell shows the last typed text, no matter where it is typed 0
Printing truncates cell contents 6

Back
Top