How do I stop cell contents from spilling into the next cell?

  • Thread starter Thread starter infofam
  • Start date Start date
I

infofam

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?
 
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.
 
Both of these suggestions will work very nicely. Thank you.


macropod said:
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 said:
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?
Click to expand...
.
Click to expand...
 
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.
 
Back
Top