Excel 2010

To modify the row height:

1. Position the cursor over the row line so the white cross becomes a double arrow .
   Positioning the mouse over the row line
2. Click and drag the row downward to increase the row height or upward decrease the row height.
   Increasing the row height
3. Release the mouse. The height of each selected row will be changed in your worksheet.
   Increased row height

To set row height with a specific measurement:

1. Select the rows you want to modify.
2. Click the Format command on the Home tab. The format drop-down menu appears.
3. Select Row Height.
   Increasing the column width
4. The Row Height dialog box appears. Enter a specific measurement.
   Increasing row height to 60 pixels
5. Click OK. The selected rows heights will be changed in your spreadsheet.
   
   

Select AutoFit Row Height from the format drop-down menu, and Excel will automatically adjust each selected row so all of the text will fit.