Preserve Row Formatting During a Sort

[Bill]

Seems like there must be a simple answer for this, but I
ain't figured it out as yet. I've got a table with 200+
rows of varying height depending on the contents of an
entry in one particular column. When I sort the data the
row formatting (height) doesn't "follow the data". I
don't want to do autofit after the sort since I want to
maintain a minimum row height. Thanks for your assistance.

 

[Guest]

I don't know if this is feasible for your situation... if you highlight the entire rows that contain the data to be sorted, I think Excel will sort the row heights as well. I'm guessing this is generally not going to be an option, but maybe it could help

Art