I have a very large excel doc (well over 1,000 rows, by 30 something columns) that require formatting (resizing the row height) each row by hand. I have done all of that tideous work, but now I need to sort by multiple columns, and when I do that, the formatting of the cells is not maintained. (The size of the row stays, rather than moves with the data) Please tell me there is a remedy and I haven't just wasted my time formatting for nothing! Thanks for any and all advice.