Using Excel 2000. I have a large workbook where several cells contain more text than what Excel wants to view in a cell by default (I've read there is a 1024 character limit). Even with text wrap, the cell would not show all the text. I have forced the view by inserting hard returns (Alt+Enter) at the end of lines and have manually adjusted the row height. This is fine until I do a sort of any kind. Upon a sort, Excel wants to auto-adjust the row height of the large rows back down to some pre-determined default size that will only show a given amount of text. I'm looking for a way to stop the auto-adjustment of the row height upon a sort.