Here is the problem: Say, a merged cell (multiple rows and columns) has some arbitrary lengthy sentence for its content. If I double click between the line numbers on the left in order to vertically resize the cell to snugly fit the text, the size of the merged cell reduces to smallest default size, and the sentence reduces to a single line, such that only some the text (of the lengthy sentence) in it are displayed truncated.

Experimenting with the same sentence in an unmerged single cell however, shows no problems as such. It seems to me that merged cells do not behave like single unmerged cells.

How to do I vertically align a merged cell to the text content such that its content will always stay visible, and not truncated.

You should stay away from merged cells as much as possible. As you experienced they are nothing but trouble. Instead try formatting like " Center across selection"

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes, but what if I don't want to center the text?

paik1002: I see you posted essentially the same question in the Word forum: https://www.msofficeforums.com/word-...cell-text.html

Kindly post in only the forum to which the subject matter relates. As it is, there is nothing about your posts in either forum that identifies with any certainty which application the query relates to.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, but not on purpose though. How do I delete my post on the Word forum?

Done. It would have been courteous for you to have edited or replied to that thread indicating it was in the wrong forum before it was replied to ... something you were clearly aware of within minutes of posting there.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you. Will reply the next time something like this happens again.