Hide

Adjusting rows height

You can download here the worksheet from this video to practice it by yourself!

Why and when is it useful?

By default, the row height is adjusted automatically by the size or style of the cell's content, so you won’t have to take care of this by yourself.

But there are cases when you wish to set their specific height by yourself, mostly to be taller than the content.
This could be to achieve better readability, when you feel the content of the cells is too clustered up, or for setting a better layout of the sheet on the page before being printed.

How do you adjust the rows height?

Select the rows by clicking the middle of the row's header and dragging up or down until you cover the rows you want to adjust.

Then, drag the top or bottom edge of a row's header in order to adjust the height manually, or you can double click the top or bottom edge of the row's header in order to have it resized automatically.