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

[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?

 

[macropod]

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.

 

[Gord Dibben]

Format the cells to Wrap Text.


Gord Dibben MS Excel MVP

 

[infofam]

Both of these suggestions will work very nicely. Thank you.

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]

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?

.

 

[infofam]

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.