

Double clicking row edge to set height automatically:

Using the context menu (right click) to set the height manually:

Using the ribbon menu to set the height manually:
Next:

Next:

Result:


Setting the height of multiple rows at the same time:
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 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.