View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
infofam infofam is offline
external usenet poster
 
Posts: 3
Default How do I stop cell contents from spilling into the next cell?

That's helpful. Thank you. I had hoped to keep the entries one line high,
so I will make the height fixed as macropod suggest below. That will do it.

"Russell Dawson" wrote:

Format - cell format - alignment - wrap text
This will however have the effect of increasing the height of the row.
--
Russell Dawson
Excel Student


"infofam" wrote:

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?