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

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?

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?

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

Format the cells to Wrap Text.


Gord Dibben MS Excel MVP

On Mon, 15 Feb 2010 08:15:01 -0800, 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?

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

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?

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

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


"macropod" wrote:

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

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?