Limited number of characters in a cell

J

Jim

I am adding information to a cell, but only part of it is
visible, no matter how large the size of the cell or how
small I make the fonts. Is there any way to make a cell
show all of the information?
 
B

Bernard V Liengme

Hi Jim:
Taken from Help using search term "specifications"

Column width 255 characters

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


Have you thought of using a text box. If you really need the text in a cell,
you may be better off with Access

Best wishes
bernardLiengme
 

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

Red cell for negative numbers in Excel 1
Total Cell Characters Count 1
Excel 2003 - Maximum number of characters a cell can contain? 1
limit number of characters in cell 4
Format a Cell 1
Expanding Capabilities of Wrap Text in a cell 1
How can the number of words per cell in Excel be increased? 8
limit # of chars in a cell 1

Top