View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Non-Bleeding Cells

Is there a way to format a cell so that it only displays its contents in the
current cell rather than appearing to "bleed" over to the adjoining cells.
In other words if the cell contained the text string "Now is the time for all
good men" and the cell was only 10 characters wide, on-screen you would only
see "Now is the" because that is all that would display. If this was in cell
A1, cell B1 would appear empty. What happens now is that the contents just
display across all the cells it needs in order to show the whole sentence. I
don't want to wrap the text. I don't want to change anything in any way
other than have the contents appear truncated so B1 is "empty". Thanks.