Question: I have a cell with wrapped text content in Excel and I want to format the cell so that its height will adjust to fit the content which can span over several lines. How can I achieve this behavior?

Answer: 
If it doesn't automatically do it, then place your cursor over the small line between row numbers (ex: between 1 and 2) and double click, this will resize the row (directly above the small line, in the example: 1) so that everything is visible (from a vertical aspect).
Do you know macro? Put the following code in 

> 
> Application.ActiveCell.WrapText = True
> 
> 
> 

inside your Worksheet\_SelectionChange subroutine.