The best magazine
- 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.
Source: ...