preventing text from spilling into next cell/column

[helpmeplease1]

Simple question, I just have not found the answer anywhere. I'm using Mirco 2003

When I enter text in say cell/column B3 I do not want it to spill into cell/column B4. I just want to keep the cell/column the same size and have the text hidden behind the future cells(b4, b5, etc.)

This way, when I type in B4 with new text it isn't hidden, and I can keep my chart on one page.

Can you please help me with this. Thank you!

 

[c8503]

quick & dirty way is to just put a space in the next cell - b4, b5 etc: hit the space bar and then hit enter.

basically if the other cells are not empty it will hide the extra text that's "spilling over"

adding a space character is a way to make them not empty

 

[helpmeplease1]

That's awesome!! thank you !

Is there a place you can direct me that would show me how to highlight all of the cells/columns so that this just happens automatically for every cell i type in?? I need this for all the cells not just the b column, etc.

 

[itsdone]

Hello guys...

One more solution is there for the same prob...
which I feel is better than writing some thing to the excel..

You can do it in below ways..
1. First make "Wraptext" on for the required column/cell (Set wraptext = true).
2. Fix the row height (Set rowheight for the required row/all the rows in the sheet = 15 or some value)

e.g. xlapp.ActiveSheet.columns("A:H").wraptext = True xlapp.ActiveSheet.columns("A:H").rowHeight = 15

Please let me know if you have any doubts

Regards,
itsdone1989gmail.com