Leave wrap text enabled and manually set the row height.

What is happening is the row will Autofit with wrap text enabled.

By pre-setting row(s) to a manual height the data won't overlap.


Gord Dibben MS Excel MVP

On Mon, 05 Nov 2007 08:53:23 -0800, wrote:

On Nov 5, 11:43 am, "Niek Otten" wrote:
It depends on the setting of FormatCellsAlignment tabWrap text


Cool, that solved it.
I was confused because somehow certain cells (B1, B2) had the
alignment off and the others had it on, so I wasnt sure why some would
wrap and some wouldnt.

Now, one other thing.
When you take off the "Wrap" you can see the cell contents seem to
over lap the cell in the next column (C1) UNLESS you have something
type in C1.

Is there a way to stop the overlap?
I sometimes put a space in the next column, but I was wondering if
there is a setting for that.

Thanks