Very long cell problem.
Very long cell problem.
(OP)
It seems that when I write very long paragraph in a single cell after a while MS Excel do not show the text in main window and do not print it, even if the text is correcly shown in the formula bar.
I'd really like keep all text in a single cell, any work around?
Thanks
I'd really like keep all text in a single cell, any work around?
Thanks





RE: Very long cell problem.
RE: Very long cell problem.
Exactly how many characters do you mean by "very long text"?
Brian
RE: Very long cell problem.
It is very useful to have some narative description of the worksheet that you develop, explaining the basis, the limitations and some instruction how to used the worksheet. This is especially true, when you dont use the worksheet very often or for someone to use your worksheet.
Melko, did you try wrapping the cells?
RE: Very long cell problem.
RE: Very long cell problem.
Just for info, this is what I've found for limits in Excel
Microsoft Excel 7.0 (95)
-----------------------------------------
· Maximum Sheet Size: 16,384 rows by 256 columns
· Column Width: 0 to 255 characters
· Maximum length of cell contents (text): 255 chacters
Microsoft Excel 8.0 (97)
--------------------------------------------
· Maximum Sheet Size: 65,536 rows by 256 columns
· Column Width: 0 to 255 characters
· Maximum length of cell contents (text): 32,000 characters
Microsoft Excel 2000
--------------------------------------------
· Worksheet size: 65,536 rows by 256 columns
· 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.
RE: Very long cell problem.
2. Format cells/Alignment/Wrap text.
3. Use Alt+Enter to start new line in same cell.
I think this should solve display/printing problem.
GoodLuck!
RE: Very long cell problem.
Thanks anyone.
RE: Very long cell problem.
RE: Very long cell problem.
Regards,
Joerd
RE: Very long cell problem.
For instance, I may have several worksheets and on the last one I put a big textbox and write instructions in it telling users (and me!) how to use the other worksheets!
Brian