View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cindy Cindy is offline
external usenet poster
 
Posts: 6
Default keeping text in 1 column

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