How to Set Row Height in Excel 2007

1. Open the Excel spreadsheet. Select the rows for which you want to set the row heights. Click on a row in the left column to select the entire row. Press and hold 'Ctrl' and click more rows to select multiple rows, or click the diagonal arrow in the top-left corner of the spreadsheet, above the first row, to select every row.
2. Click the 'Home' tab from the Ribbon if it's not already selected. Click on 'Format' from the Cells section and select 'Row Height.' This opens a dialog box.
3. Type a number into the text box and click 'OK.' This sets the row height for your selected cells to the number you entered.