1. Home
  2. The Basics

  3. Row Heights

Row Heights:

Changing the height of rows

As with the width of a worksheet column, the height of an individual row, or all rows, can be adjusted to better fit their content. Setting row heights appropriately can greatly enhance the presentation of your data.

A row's height can range from of 0 (zero) to 409. A row that has its height set to 0 (zero) is hidden. The default row height depends on the default font for the worksheet. For example, if you are using the Calabri font in a point size of 9, the default row height is 12. There are several methods to change the row height.

#1)
Dragging row edge with the mouse to set height manually:
This method is most useful when you need to quickly set the height of a single row.
Note:
See also Column Widths
#2)
Double clicking row edge to set height automatically:

Before:

This method is most useful when you want to automatically fit the tallest content of any cell in the row.

After:

Note:
The resulting row height may or may not be consistent with other rows.
#3)
Using the context menu (right click) to set the height manually:
This method is most useful when you know the exact height you desire.

First:

Note:
You can also get to this point with a keyboard shortcut by pressing sequentially (don't hold keys down) the Alt, H, O, H keys. But this hardly seems like a "shortcut"!

Next:

Note:
Setting multiple rows to the same height is illustratedbelow.

Result:

#4)
Using the ribbon menu to set the height manually:

First:

This method is fine, but it's not the most convenient.

Next:

Next:

This is the same point reached in method above.

Result:

#5)
Setting the height of multiple rows at the same time:
All of the above methods can be applied to multiple rows. To do this, start by selecting your rows and then follow the same procedure as for a single column.

Selecting Adjacent Rows:

Note:
Selecting non-adjacent columns, rows and cells all work in the same manner. Hold the Ctrl key down and click on each of the items you want to select.

Selecting non-adjacent rows:

Summary

There are several ways to change the row height. It's matter of preference depending on how often you need to do this. The easiest method is generally method above whereby the row height is set to automatically fit the tallest content in any of the cells in the selected row. If you need to set specific and consistent heights for your rows, any of the other methods are easy.