--
make the change


"Cindy" wrote:

Thanks for the reply... and yes, I realize that -- but there is too much
text, that is not an option. I forgot to mention that in the first post.

--
Cindy B


"cm" wrote:

Cindy,

If you set that column wide enough to accommodate your longest text string,
it will not wrap or flow over.

"Cindy" wrote:

How can I keep text from overflowing into the next column - if the cell is
blank?
I've tried text wrap - which works, but than the cell row expands - which I
don't want. I know I can manually set it back, but I have a large sheet
where I will run into this many times --
It doesn't seems logical to set the column to textwrap to keep it from
running into the next cell -- but then having to manuually set each cell back.
Any suggestions? anything I can do to the column to the right to keep it
from accepting overflow text? I tried textwrap - but that did not make any
difference....
Thanks for any recommendations you might have!!!

Cindy
--
Cindy B


Hello I am facing the same issue , unfortunately all the 3
reponses/solutions have not worked. Please provide some more options. Here I
am using an excel sheet shared by another person. He has managed to get this
perfect. The data that we cut and paste into the shell will appear to ROLL
DOWN, from the formula bar in a clean and neat manner. Hence to read the
whole content, All i need is to keep the mouse on the coloumn. How to achieve
this ? I dont want to ask the other person manually. some one please help