How to Avoid a Long Text Covering the Next Cell

[Ceeyee]

I have some long text but I don't want them to cover the cells in the next columns.

I am currently putting a " " in the next cell so that the text go behind it but I want to find a better solution, i.e don't need to put things in the next cell. I would also avoid using Wrap because it messes up with the row heights.




Got any ideas?

Thanks.

 

[Gary McMaster]

Try setting the horizontal justification for the cell(s) to "Justify".

Gary

 

[jmthompson]

Or to "fill"

Try setting the horizontal justification for the cell(s) to "Justify".

 

[Ceeyee]

Great, thanks.

 

[Ceeyee]

Wait a minute...
The Justify method expands the row heights which is not what we want..