Excel 2002 - 2 Word Wrap Promlems in List

1. When a cell is formatted for word wrap the text wraps OK but the row does not increase in height auotmatically to fit the text. You have to manually increase the row height. I am sure this feature is available as I have used it before and the row height increase as you type.

2. To make the above problem worse when you sort the list by a different column the row with the increased height does not move with the data and stays where it is. The data has now moved to a strandard sized row and is not all visible.