Auto Row Height Not Working in Excel (2 Quick Solutions)

Get FREE Advanced Excel Exercises with Solutions!

A quick guide to solve the problem when the Auto Row Height command is not working properly in Excel. You will learn two quick methods with sharp steps and vivid illustrations.


Auto Row Height Not Working in Excel: 2 Easy Fixes

Let’s get introduced to our dataset first that contains the 5 best-selling books at Amazon in 2021.


1. Manually Input Row Height or Unmerge Cells

You will face the problem when you will want to automatically fit the wrapped text in merged cells. Have a look that now I have merged Column C and D to type the book names.

Manually Input Row Height or Unmerge Cells

Now if I try to AutoFit the row height then it’s not working.

Manually Input Row Height or Unmerge Cells

Output after applying the AutoFit Row Height command, it has just come into one line but is not showing the full text as the column width is fixed.

Manually Input Row Height or Unmerge Cells

Solution:

You can solve it in two ways.

The first way is to change the row height manually.

Select the cell and click as follows: Home > Cells > Format > Row Height.

Manually Input Row Height or Unmerge Cells

Type a larger row height than the present height.

Later, just press OK.

Manually Input Row Height or Unmerge Cells

Now the cell is fitted perfectly.

Manually Input Row Height or Unmerge Cells

The second way is to unmerge the merged cells.

Select the cell and then click as follows to unmerge: Home > Merge & Center > Unmerge Cells.

Manually Input Row Height or Unmerge Cells

After that, Double-click the lower border of the row number of the cell.

Now the row is fitted.

To merge again just select the two cells and click Merge & Center from the Home Tab.

Here’s the final outlook.


Similar Readings


2. Use VBA Macro When the Auto Row Height Is Not Working in Excel

The easiest and handy way is to use VBA Macro when the AutoFit Row Height command is not working.

First, select the cell.

Then right-click on the sheet title.

Click View Code from the context menu.

VBA Macro When the Auto Row Height Is Not Working in Excel

After appearing the VBA window write the following codes-

Sub AutoFit_RowHeight()
    With Selection.CurrentRegion
        .Rows.EntireRow.AutoFit
    End With
End Sub

Later, press the Run icon to run the codes.

A Macros dialog box will open up.

VBA Macro When the Auto Row Height Is Not Working in Excel

Select the Macro Name as specified in the above codes.

Finally, press Run.

VBA Macro When the Auto Row Height Is Not Working in Excel

Now the cell is fitted with the text properly.

VBA Macro When the Auto Row Height Is Not Working in Excel

Read More: VBA to Customize Row Height in Excel


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


Conclusion

I hope the procedures described above will be good enough to solve the problem when the AutoFit Row Height command is not working properly in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo