Hi,

I have a spreadsheet which is a list of varying heights of rows depending on the amount of text. There are about 6 columns and I am using Excel 2002 on Windows XP.

I have set autofit to all of the rows so that when I paste text into a row the row automatically adjusts in height to fit the text.

The problem is that when I sort the data by a different column the row height does not move with the data and the text does not fit. For example row 20 may be 25 points high to fit the data but when the data is re-sorted row 20 is still 25 points high and the data that ends up in this row may be a single line or numerous lines which are then partially hidden.

Is there way to tie the row height to the data so that when sorted they move together?

Axel