overflow text.

[M]

Is there any way to stop text from one cell flowing into blank cells
to the right of the cell?

 

[JE McGimpsey]

Is there any way to stop text from one cell flowing into blank cells
to the right of the cell?

One way:

Put a space character in the cell to the right.

Another:

Set the cell to Wrap Text (Alignment pane of the Formatting Palette, or
Format/Cells/Alignment). This will automatically increase your row
height, but you can set it back.

 

[CyberTaz]

This will automatically increase your row
height, but you can set it back.

<snip>

....or, alternatively, you can manually adjust the row height by a hair (or
whatever) _before_ entering the content to prevent it from automatically
increasing.

 

[M]

One way:

Put a space character in the cell to the right.

Another:

Set the cell to Wrap Text (Alignment pane of the Formatting Palette, or
Format/Cells/Alignment). This will automatically increase your row
height, but you can set it back.

Thanks. It works. Not elegantly, but after this is MS.

 

[M]

<snip>

...or, alternatively, you can manually adjust the row height by a hair (or
whatever) _before_ entering the content to prevent it from automatically
increasing.

I'm sorry I'm new to Excel, could you please tell me how to do that.
I've tried a couple of things and they don't seem to work.

 

[CyberTaz]

Sure - Position your pointer on the separator between two row number
headings. The pointer will appear as a crosshair-type & you can drag the
separator up/down to change the height of the row.

 

[M]

Sure - Position your pointer on the separator between two row number
headings. The pointer will appear as a crosshair-type & you can drag the
separator up/down to change the height of the row.

Thanks. But changing row and column height/width doesn't stop text
from flowing from one cell into the next.

 

[CyberTaz]

Not unless the cell is formatted to Allow Text Wrap - that's what prevents
the overflow. Manually adjusting the row height prevents the row height from
automatically increasing as you enter content into the cell.

HTH |:>)
Bob Jones
[MVP] Office:Mac