multiline in excel but no auto row expanding...

[sectorboot]

This is weird just start to happen one day and continue acting weird.

Multiline in excel (cell allign property set to warp) no longer expand the row automatically as it is supposed to when the text flows to next lines.

Texts is there but in a usual single line.

I need to force people to key in one data to one cell so they don't run into problems when they filter or sort the table.

Help ?

Thanks in advance.

BootSector

 

[SkipVought]

Hi,

Could be that you have text wrap in a merged cell. Auto row height does not work with merged cells.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[sectorboot]

Skip...

I've checked...
The particular cell I refer to is not merged but some of the cell in that worksheet are merged.

Is this normal ?