I have a worksheet that has wrap text enabled on a column of cells and whenever I enter more text than will fit in a cell, it will word wrap to the next line, but it won't change the height of the cell (you have to click on the cell to see the entire contents).

Now I have another sheet I would like to do this on but I have been unable to replicate it. Whenever I enable word wrap, it automatically adjusts row height to fit the text in, which is not what I want.

Anyone know what to do?