If your cell is set to wrap, then the row height usually adjusts automatically when text is entered. I don't know what your circumstances are in which this is not happening, but the method to adjust the height is .Autofit.