Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
I am experiencing a problem with populating cells with long text information
(hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
Try using some <Alt <Enter (forced line breaks) at appropriate places in
the text. This should increase the amount of visible, displayed text. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Elizabeth" wrote in message ... I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
hi,
In excel help, type the word specifications. from the specs... Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. regards FSt1 "Elizabeth" wrote: I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
horses for courses - would Word be better for these purposes?
James "Elizabeth" wrote: I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
Thanks very much for your help. This told me what I needed to know. It's
not what I wanted to hear, but at least I know that there isn't a way to format the cell differently to get it to show the text. "FSt1" wrote: hi, In excel help, type the word specifications. from the specs... Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. regards FSt1 "Elizabeth" wrote: I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
I guess you *didn't* read my post!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Elizabeth" wrote in message ... Thanks very much for your help. This told me what I needed to know. It's not what I wanted to hear, but at least I know that there isn't a way to format the cell differently to get it to show the text. "FSt1" wrote: hi, In excel help, type the word specifications. from the specs... Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. regards FSt1 "Elizabeth" wrote: I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
Yes, I did read your post. I thank you for your interest in helping me too.
Unfortunately, I cannot use your solution because I have way too many cells with this condition. It would take me a very long time to complete this type of manual formatting. Thank you very much, Elizabeth "Ragdyer" wrote: I guess you *didn't* read my post! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Elizabeth" wrote in message ... Thanks very much for your help. This told me what I needed to know. It's not what I wanted to hear, but at least I know that there isn't a way to format the cell differently to get it to show the text. "FSt1" wrote: hi, In excel help, type the word specifications. from the specs... Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. regards FSt1 "Elizabeth" wrote: I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format in spreadsheet cells
Would suggest you post to the programming group.
There might be a simple solution using code. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Elizabeth" wrote in message ... Yes, I did read your post. I thank you for your interest in helping me too. Unfortunately, I cannot use your solution because I have way too many cells with this condition. It would take me a very long time to complete this type of manual formatting. Thank you very much, Elizabeth "Ragdyer" wrote: I guess you *didn't* read my post! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Elizabeth" wrote in message ... Thanks very much for your help. This told me what I needed to know. It's not what I wanted to hear, but at least I know that there isn't a way to format the cell differently to get it to show the text. "FSt1" wrote: hi, In excel help, type the word specifications. from the specs... Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. regards FSt1 "Elizabeth" wrote: I am experiencing a problem with populating cells with long text information (hundreds of words). It will only show a portion of the text when viewing on screen or printing the document. However, when you click on the cell, it will display all the text. Does anyone know if there is a software limit on visible text in a cell? I have wrapped the text and tried to resize the cells, but nothing works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
viewing shaded cells or text in spreadsheet | Excel Discussion (Misc queries) | |||
format cells when containing specified text | Excel Discussion (Misc queries) | |||
format cells having text | Excel Discussion (Misc queries) | |||
Format text across cells | New Users to Excel | |||
How do I put drawing objects behind text/cells in a spreadsheet? | Excel Discussion (Misc queries) |