if you highlight the whole sheet, then double click where you would adjust a row height, all rows will auto adjust to display all data.