AutoFit Row Height In Excel

Article byJeevan A Y
Edited byNannila Jai Ratna
Reviewed byDheeraj Vaidya, CFA, FRM

What Is Excel AutoFit Row Height?

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.

Autofit Row Height Intro

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.

Intro - Output

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.

Key Takeaways

  • 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.

How To Change Default Row Height?

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.

Autofit row height Method 1

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

Autofit row height Method 1-1

Once the row height is fixed, we can apply the same formatting to other rows using  format painter excelFormat Painter ExcelFormat painter in Excel is a tool used to copy the same format of a single cell or a group of cells to the other cells. You will find it on the home tab in the clipboard section.read more.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

AutoFit Row Height In Excel

Like how we have changed the row height per our preference, we can auto-adjust the row height with a click of a button.

Auto adjustment of the row height depends on the data size of each row cell. Now, let us learn how to autofit row height in Excel.

Examples

Example #1

Consider the below table showing monthly sales and GP%.

Autofit row height Method 1-2

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

Autofit row height Method 1-3

Now, our new height may look like this.

Autofit row height Method 1-4

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

Autofit row height Method 1-5

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

Autofit row height Method 1-6

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

Autofit row height Method 1-7

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

Autofit row height Method 1-8

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.

Method 2-5

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

Autofit row height Method 2-6

Likewise, we can auto-adjust rows in Excel.

Method 2-7

One more method is using excel shortcut key optionsUsing Excel Shortcut Key OptionsAn Excel shortcut is a technique of performing a manual task in a quicker way.read more 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.

Autofit row height Method 2-8

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

Important Things To Note

  • 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.

Frequently Asked Questions

1. What is autofit row in excel?

Autofit row height in Excel method helps users adjust the size of the row in the worksheet based on the length of the text string.

The default row height is based on the font size set when we open an Excel file. If no changes are made to the default settings, the default font name is “Calibri,” and the font size is “11”, so the row height is 15 points, equal to 20 pixels.

2. Explain autofit row in excel with an example.

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.

Autofit Row Height FAQ 2

To autofit the row height, simply click on the line between row 1 and row 2.

FAQ 2 - Output

Likewise, there are other ways to autofit row height in Excel.

3. What is the use of autofit row in excel?

Suppose you have a data set where the text spills out to the other columns as its width is smaller. Excel has certain limitations on height and column width. Hence, when we insert anything that occupies more space than the current size, we can notice that it spills out. In this situation, we can adjust the rows and columns to fit the text in the cell completely using the AutoFit function in Excel that can accommodate the text for multiple columns and rows, adjusting the column width and row height at once.

Autofit row height basic 1

We need to click on the bottom of the row header to see the row height. It will display the row height of the selected row.

Autofit row height basic 1-1

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: –