Hi guys,
I have some text which is centred across selection and the text wrapped so that it resizes nicely and this has been fine. However, today, I have come across a problem. I autofit the height of the cells at the end and I am finding that the row is autosizing to double character height even though there is in fact only a single row of characters. If I add or remove a few characters, normal behaviour is resumed - few less characters and the row resizes to singly, few more and it is double but some characters have now moved to the second 'character' line.
The question is... can I rectify this? I would rather not have to tell the end user that he simply has to keep his eyes open and change his sentence a bit if it happens!
Many thanks
Edit to add: I have been playing about with this and it even happens when I put the text into a single cell of the same width.... it seems although, when the text is close to the width of the containing area that excel gets the autoheight wrong.
Bookmarks