Hello-

Excel will automatically adjust the row height if it has not already been
manually adjusted. Excel apparently believes that if you set a row height to
something other than the default, that you want the row to stay at that
height unless you change it yourself.

If you select the area involved and go to FormatRowAutofit it should fix
the problem.

BTW- Column width works the same way... unchanged columns will automatically
adjust when you apply number formatting, but only if you have not previously
changed the width of the column.

HTH |:)

"Confused" wrote:

I selected wrap text, but Excel isnt showing all the contents of the cell
until I change the vertical height of the cell manually. It used to do this
automatically. Can anyone help me?