Cell data not visible (I have wrapped text & resized)

G

Guest

Even though I have resized the cells and wrapped text, the total contents of
cells with a lot of data in them are not visible in the worksheet. The full
cell contents are only visible in the formula bar.
 
J

JE McGimpsey

XL has a limit of 1024 characters that can be displayed or printed in a
cell, even though the max length of a cell is 32767 chars.

One workaround is to manually enter a linefeed (ALT-ENTER) at least
every 1024 chars.
 
G

Guest

Thanks JE McGimpsey.

JE McGimpsey said:
XL has a limit of 1024 characters that can be displayed or printed in a
cell, even though the max length of a cell is 32767 chars.

One workaround is to manually enter a linefeed (ALT-ENTER) at least
every 1024 chars.
 

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