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?

Is that a merged cell?

If yes, the autofitting the rowheight won't work.

Have you changed the rowheight manually? If yes, then excel will respect that
setting until you autofit the rowheight once more.

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?

--

Dave Peterson

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?