Modifying Row Heights

When you first enter data in your workbook, Excel automatically sets the rows of your worksheet according to preferences. You may find you want to make rows a different height from this default setting.



To modify row heights:

  1. Select the row or rows you want to change.
  2. Drag the boundary until the row is the height you want.


  • If you want to change all the rows in your worksheet to the same height, click the Select All button (the gray box above Row 1 and to the left of Column A) and then drag the boundary.
  • Double-click the boundary (or select AutoFit from Row on the Format menu) to make the row automatically fit the contents.

To change the height of a row, you can also point to Row on the Format menu and select Height.... Enter the exact height of the row and click OK.