How to adjust row height in excel automatically

The tutorial shows different ways to change row height and resize cells in Excel.

By default, all rows on a new workbook have the same height.

However, Microsoft Excel allows you to resize rows in different ways such as changing row height by using the mouse, auto fitting rows and wrapping text.

How to adjust row height in excel shortcut

Further on in this tutorial, you will find full details on all these techniques.

Excel row height

In Excel worksheets, the default row height is determined by the font size. As you increase or decrease the font size for a specific row(s), Excel automatically makes the row taller or shorter.

According to Microsoft, with the default font Calibri 11, the row height is 12.75 points, which is approximately 1/6 inch or 0.4 cm.

In practice, in Excel 2029, 2016 and Excel 2013, row height varies depending on the display scaling (DPI) from 15 points on a 100% dpi to 14.3 points on a 200% dpi.

You can also set a row height in Excel manually, from 0 to 409 points, with 1 point equal to approximately 1/72 inch or 0.035 cm.

A hidden row has zero (0

how to increase row height in excel shortcut

how to increase row height in excel past 409