Wrapping doesn't collapse rows

[tshad]

I have a column that allows wrapping.

But if I widen the column so that all the text is on one line or less lines
that they were, the rows don't collapse to the smaller size. I have to
manually go to each row and make them smaller by hand.

Is there a way to tell Excel to make the rows only as large as the text
after I widen the column? It does that if I shorten the width - it makes
the rows larger, to the size of each row.

Thanks,

Tom

 

[Dave Peterson]

I use xl2003 and I don't see the rowheight adjust when I widen or reduce the
columnwidth.

You could use a macro that adjusts the rows (all the rows in the worksheet or
just the rows you want), but that's not too different than selecting all the
rows you want and autofitting them at once.