View Single Post
 
Old 09-20-2016, 12:46 AM
paik1002 paik1002 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Dec 2015
Posts: 63
paik1002 is on a distinguished road
Default How to vertically align a merged cell to fit text

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.
Reply With Quote