Please help me! By default when I write some text in cell and the text is
longer then cell's width, I can not see his contents in next cells. But in
one excel file when I sellect all cells in worksheet and then draging them it
can no longer seen all contents in one cell. What I should to do? Thank you
in advance!

If you have wraptext turned on (format|cells|alignment tab), then the cell will
expand its rowheight to show you all the data. (unless you use merged cells or
have adjusted the rowheight manually).

If you have wraptext turned off, then the text will overflow to the cell to the
right--if that cell is empty. Try hitting the delete key with that adjacent
cell selected to really clear it.



:-) wrote:

Please help me! By default when I write some text in cell and the text is
longer then cell's width, I can not see his contents in next cells. But in
one excel file when I sellect all cells in worksheet and then draging them it
can no longer seen all contents in one cell. What I should to do? Thank you
in advance!

--

Dave Peterson

Hello Mr. Peterson! Thank you for your advice but the problem remains. In
entire worksheet the cells have wrap text turned off, there are no merged
cells. In another worksheet with the same cell properties, the text overflow
to the next right cells of course the cells behind the edit one are empty. I
don't know what is going on. And I don't know how this was happened. It is
very important to find a decision, because this worksheet is already full
with data and when I try to copy him the result is the same. Please help me!
Thank you!

"Dave Peterson" wrote:

If you have wraptext turned on (format|cells|alignment tab), then the cell will
expand its rowheight to show you all the data. (unless you use merged cells or
have adjusted the rowheight manually).

If you have wraptext turned off, then the text will overflow to the cell to the
right--if that cell is empty. Try hitting the delete key with that adjacent
cell selected to really clear it.



:-) wrote:

Please help me! By default when I write some text in cell and the text is
longer then cell's width, I can not see his contents in next cells. But in
one excel file when I sellect all cells in worksheet and then draging them it
can no longer seen all contents in one cell. What I should to do? Thank you
in advance!

--

Dave Peterson

I don't have any further suggestions--but I would double check that those empty
cells are really empty. (I'd select a few and hit the delete key to clear
contents.)



:-) wrote:

Hello Mr. Peterson! Thank you for your advice but the problem remains. In
entire worksheet the cells have wrap text turned off, there are no merged
cells. In another worksheet with the same cell properties, the text overflow
to the next right cells of course the cells behind the edit one are empty. I
don't know what is going on. And I don't know how this was happened. It is
very important to find a decision, because this worksheet is already full
with data and when I try to copy him the result is the same. Please help me!
Thank you!

"Dave Peterson" wrote:

If you have wraptext turned on (format|cells|alignment tab), then the cell will
expand its rowheight to show you all the data. (unless you use merged cells or
have adjusted the rowheight manually).

If you have wraptext turned off, then the text will overflow to the cell to the
right--if that cell is empty. Try hitting the delete key with that adjacent
cell selected to really clear it.



:-) wrote:

Please help me! By default when I write some text in cell and the text is
longer then cell's width, I can not see his contents in next cells. But in
one excel file when I sellect all cells in worksheet and then draging them it
can no longer seen all contents in one cell. What I should to do? Thank you
in advance!

--

Dave Peterson


--

Dave Peterson