Changing the Row Height For Multiple Rows in Microsoft Excel

By Laurie Senese

Microsoft Excel 2007 provides several simplified options that you can use to change the height of multiple rows in your worksheets. Resizing row heights makes reading and viewing the data in each cell effortless.

Using the Mouse

Select the rows you want to increase or decrease in height. To select all rows in the spreadsheet, click the "Select All" button. The "Select All" button is the triangular icon is located directly above Row 1 to the left of Column A. Roll over any row number until the mouse changes to a cross-hair. Then, left-click the mouse and drag the cross-hair up or down. All the selected rows will increase or decrease in height as you drag the cross-hair of the mouse up or down.

Using the Format Menu

Select the desired rows. To select all rows in the spreadsheet, click the "Select All" button. This triangular icon located directly above Row 1 to the left of Column A. Select the "Home" tab. In the "Cells" group, left-click the "Format" drop-down arrow and then under the "Cell Size" section click "Row Height." The "Row Height" dialog box displays. Type a number from 0 to 409 points in the field and then click "OK."

Page Layout View

Select the "View" tab and from the "Workbook Views" group click the "Page Layout" button. Select the desired rows to change. Right-click and choose "Row Height" from the context menu. Notice the row height is in inches. Select the desired inches in the field and then click "OK."