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.