I have a report I produce (Excel 2010) every month for management. It's usually 1200 to 1500 rows. The default height for each row is 32.50 but about 40-50% of the rows need to be "higher" than than to display all the content in certain cells.
If I select Auto-Fit under Home > Cells > Format...