View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 293
Default How do I stop cell contents from spilling into the next cell?

Hi infofam,

You could:
1. Format the cell to wrap text, then fix the line height so that anything over one line won't show; or
2. insert a space character into the adjacent cell.


--
Cheers
macropod
[Microsoft MVP - Word]


"infofam" wrote in message ...
I'm working with a spreadsheet and I want to fix the column width more narrow
than my cell contents. If the next column is blank, i do NOT want extra
characters to appear. I don't want them truncated, i just want to restrict
to a set width what I see in that column.

Does anyone know how to do that?