I'm so glad I'm not the only one who's head is being done in with this!! I just tried UN-merging the cells and auto height adjust does work. Very annoying - so I guess you have to manually change...