Cell Formatting

Copper Contributor

Is there a way to conditional format a cell or combined cell to auto adjust the cell height when the text alignment is wrapped. i.e increase the cell height.

Thanks in advance, Geoff

2 Replies

@Geoffrey_1950 try below steps:

Right click at the sheet name

Click on view Code

choose worksheet in place of general

write the code above End Sub, "Cells.EntireColumn.AutoFit"

exit the screen and try



Thank you for the information on the code.

I have tried the code, and the text does wrap, but when I stop entering text the row height reverts back the default height and I have to adjust the height manually to see the second row of text. 

Any further help would be appreciated.


Happy New Year.