How can I make a row expand to fit the text I type in?

When I type in text, the row seems to expand as I add more rows of type, but
when I click off of it, only the first line of text is visible. I have
checked "wrap text" but can still only see one line unless I manually drag to
make the cell larger. Can someone please help???

wrap text should do it - make sure it is on in the cell which you are entering the text.

hope you find out what is going on