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.

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.

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.

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.

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.

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.

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.

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.