How see all the text in a cell?

M

mscertified

No suitable forum for this so posting it here.

How do I see all the text in a cell? It's hundreds or thousands of characters.
Can I expand a cell to be multiple lines?
What is the secret?
Tried to find out via Help but it's useless.
 
D

David Biddulph

To expand to multiple lines, Format/ Cells/ Alignment: wrap text.
If you are still having trouble, include an "Alt Enter" every so often,
which will give a new line.
 
J

JE McGimpsey

In Help ("Specifications") you can discover that each cell can contain
32767 characters, of which the first 1024 characters can be displayed or
printed.

To work around that, you can insert LFs (alt-enter) every 1024
characters.
 

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

Top