Expanding rows

Hi,

Is there an easier way to expand rows automatically after wrapping.

I'm having to go into each worksheet and expanding by hand.

I know that you can set auto heights for rows but the content of each row differs so this wouldn't work.

Thanks