sometimes when i type a sentence in a cell smaller than the length of the
sentence, the complete sentence is visible. And then sometimes the section of
the sentence that extends beyond the cell is not visible. So, how do i make
the complete string of text visible every time it runs beyond the width of
the cell?

Thanks in advance,

If the cell(s) to the right of the cell containing the sentence
are empty, the text will be extended into the empty cells. If,
however, there is data to the right of the cell, the display will
be truncated.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tom" wrote in message
...
sometimes when i type a sentence in a cell smaller than the
length of the
sentence, the complete sentence is visible. And then sometimes
the section of
the sentence that extends beyond the cell is not visible. So,
how do i make
the complete string of text visible every time it runs beyond
the width of
the cell?

Thanks in advance,

The neighboring cells do not have data. Just in case I cleared the contents
of the adjacent cells. Still, the text is truncated... hmmmm?

"Chip Pearson" wrote:

If the cell(s) to the right of the cell containing the sentence
are empty, the text will be extended into the empty cells. If,
however, there is data to the right of the cell, the display will
be truncated.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tom" wrote in message
...
sometimes when i type a sentence in a cell smaller than the
length of the
sentence, the complete sentence is visible. And then sometimes
the section of
the sentence that extends beyond the cell is not visible. So,
how do i make
the complete string of text visible every time it runs beyond
the width of
the cell?

Thanks in advance,

Is the cell formatted to wrap text?

Format|cells|alignment tab
uncheck wrap text.



Tom wrote:

The neighboring cells do not have data. Just in case I cleared the contents
of the adjacent cells. Still, the text is truncated... hmmmm?

"Chip Pearson" wrote:

If the cell(s) to the right of the cell containing the sentence
are empty, the text will be extended into the empty cells. If,
however, there is data to the right of the cell, the display will
be truncated.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tom" wrote in message
...
sometimes when i type a sentence in a cell smaller than the
length of the
sentence, the complete sentence is visible. And then sometimes
the section of
the sentence that extends beyond the cell is not visible. So,
how do i make
the complete string of text visible every time it runs beyond
the width of
the cell?

Thanks in advance,




--

Dave Peterson