Excel AutoFit Row Height

AutoFit Row Height is a feature in Excel which allows you to automatically change the height of a Row based on the font sizes in different Cells in the Row. AutoFit Row Height command increases or decreases the Row Height in such a way to perfectly fit the largest font in any Cell of the Row.

By using "AutoFit Row Height" command, we let Excel to automatically determine how much height the Row required and adjust the Row Height to fit the largest font in any Cell of the Row.

As shown in below image, there are three Cells with different font sizes in Row number 5. The font size of text in Cell address A5 is small and its text fits perfectly in A5. But the font size of Cell address C5 is larger than the Row height, so the text in Cell C5 is cut off at top and bottom edges.

To AutoFit Row Height, select the Row and place the mouse over bottom gridline at Row number until the mouse pointer turns to a double-sided arrow. Once the the mouse pointer turns to a double-sided arrow, double-click there.

As you can see from the below image, the height of the Row is adjusted automatically to fit the size of largest font in the Cells of the Row.

An animation about how to AutoFit Row height by double-clicking the bottom gridline of Row number is copied below.

Another method to achieve the same result described above is to select the Row first and then run command "AutoFit Row Height" from Excel Ribbon > "Home" Tab > "Cells" > "Format", as shown in below image.

An animation about how to AutoFit Row height by running the command "AutoFit Row Height" from Excel Ribbon > "Home" Tab > "Cells" > "Format" is copied below.