Autofit Row height in Excel is a method used to autofit the size of the cell in Excel. After working with the worksheet, we may need to adjust the width and height of the rows and columns according to the data structure. We can change the default height and width of the size of the rows as per our requirement.

Consider the below example showing the text string, ‘Rows’ in cell A1. Now, the size of the cell is bigger and not correctly fitting the text string.

To autofit the row height, simply click on the line between row 1 and row 2. We can see the row height is automatically adjusted to based on the text string.

Likewise, there are other ways to autofit row height in Excel. In this article, we will show you how to use Excel AutoFit row height.

• Autofit row height in Excel is a method used to change the size of the row’s height in Excel worksheets.
• This is very useful when we have lengthy text strings or when we have to adjust the size of the row.
• Also, the size of the row height in Excel depends on the font size we set when opening a new workbook.
• To autofit row height in Excel, we can simply double click on the rows and we can see the height of the row is automatically adjusted.

We can change the row height in Excel from 0 to 409 points. So, a common way of changing the row height is dragging the row border upwards to decrease the row height and dragging it downwards to increase the row height.

As we are dragging, we can see the changing points and pixels of row height on a real-time basis.

Once the row height is fixed, we can apply the same formatting to other rows using  format painter excel.

Example #1

Consider the below table showing monthly sales and GP%.

Now, we will change the second-row height to 24 points.

Now, our new height may look like this.

Now, we want the same row height for the remaining row. We will select the entire row by pressing the “Shift + Space” key.

Now, we will click on the “Format Painter” option under the “HOME” tab.

Next, we will apply the format painter brush to all the rows.

We will leave our left-click on the mouse and see the magic.

It has changed the row height of the remaining rows as per the row height of the selected row, i.e., row number 2.

Example #2

Now, let us use the same example. We will learn how to auto-adjust row number 2.

We will place our cursor at the bottom of the row.

Double-click as soon as we see the above four side arrow keys. Our row gets auto-adjusted according to the contents of the row.

Similarly, to auto-adjust the row height for the remaining rows, we must select all the rows first.

We will double-click on the bottom of any selected rows.

Likewise, we can auto-adjust rows in Excel.

We can also auto-adjust the row height using the other two methods – “Manual Method” and “Shortcut Method.”

After selecting the rows under the “HOME” tab, go to the “Format” option and click on the “Format” option drop-down.

From the drop-down options, we choose the option called “AutoFit Row Height.”

Likewise, we can auto-adjust rows in Excel.

One more method is using excel shortcut key options ALT + O + R + A. After selecting the row’s height that needs to be auto-adjusted, we press the above shortcut key, and our row height will be auto-adjusted.

We do not need to hold keys but press one after the other to auto-adjust the row height.

• Autofit row height in Excel is used to change the height of the row.
• We can use the format painter option to adjust the other rows.
• Row height depends on the size of the content in the rows.

This article has been a guide to AutoFit Row Height in Excel. We discuss how to AutoFit row height in Excel with different methods and practical examples. You may learn more about Excel from the following articles: –

• Autofit in Excel
• Excel Row Header
• Calculating Return on Investment in Excel
• Excel Column Auto Width