How to change row heights in Excel

In this lesson we'll look at how to set row heights in Excel.

The default row height in Excel is determined by the font size. As you increase or decrease the font size, Excel will adjust the row height to fit. However, you can still adjust the row height manually.

Let's take a look.

All rows in Excel have a set height. To check on the current height of a row, just click the row divider at the bottom. You'll see the height displayed in points.

You can set the height of a row by dragging the row divider to make the row taller or shorter.

It's also possible to set the row height numerically. With at least one cell selected in the row, click the Format button on the ribbon, choose Row Height from the menu, and type in a new height.  Then click OK.

You can get to the same Row Height dialog box by selecting a row and right-clicking. Then, choose Row Height from the menu.

Using these same techniques, you can set the row height for more than one row at a time.

Excel can also autofit rows.  To use autofit, just double-click the row divider at the bottom of the row you'd like to resize.

You can also autofit rows by using the ribbon. Click the Format button and select Autofit Row Height from the menu.

Finally, you can autofit multiple rows at the same time using both methods. First, select the rows you'd like to autofit. Then, apply Autofit by using the Format button on the ribbon or by double-clicking a row divider in your selection.