M
M
Is there any way to stop text from one cell flowing into blank cells
to the right of the cell?
to the right of the cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
M said: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.
C
CyberTaz
<snip>This will automatically increase your row
height, but you can set it back.
....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
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
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.
C
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.
headings. The pointer will appear as a crosshair-type & you can drag the
separator up/down to change the height of the row.
M
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.
C
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
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