I am looking for the equivalent solution to this issue but to automatically control the way rows are automatically expanded based on content - ie in the same way as you select a specific row or worksheet and set rows to autofit height. It is easier column widths but with rows, it is quite important for reports where your users are dependent on seeing all data but know nothing about manipulating excel spreadsheets. I could not seem to find a way to do this nor have i seen anything referring to row heights in the forums.

 Any help greatly appreciated.