Formatcellsalignment and select text wrap, will keep it from overflowing,
it will expand row size, I guess the reason it does not flow over in one
sheet is that the adjacent cell is not empty

--
Regards,

Peo Sjoblom


"Archer------------" wrote in message
...
I am trying to copy and paste info from one cell to another. My original
cell has 50 words in it and when you look at the cell, only a work or two
is
dosplayed. When I double click on this cell it displays the entire text -
which is good. My problem is when I copy info to a blank cell, the entire
text displays across my worksheet and will not hide as my original cell.
How
do I format the cell that I am copying into to look like the original
cell.

Archer