Cell size 2007

S

Shane Devenshire

Hi,

the answer is version dependent:

2003:
Cells can contain 1024 characters in a formula
Cells can contain 32,767 text characters but only the first 1023 will be
visible (unless you use Alt Enter to force line breaks)

2007:
Cells can contain 8192 characters in formulas
Cells can contain 32,767 text characters in cells and all can be seen and
printed without needing to use Alt Enter.

If this helps, please click the Yes button,

Cheers,
Shane Devenshire
 
T

tinks

If we specifically open up a cell with many text characters, we can see them.
The problem is when the spreadsheet is opened "autoadjust" for the rows does
not show all of the characters present. Is there a fix for that?
 

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

Cell Formats - Limit # of characters 3
Set max characters in cell (Excel 2007) 4
Excel 2007 Character Display 2
What is the text limit for a single cell? 3
Why can't I get more than 255 characters in one cell in Excel 07? 1
Excel text export limit - 1024 per line (not cell), workaround? 11
limit # of chars in a cell 1
Add a limit of 140 characters to any cell 1

Top