Auto Row Height Not Working in Excel (2 Quick 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.


Download Practice Workbook

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


2 Excel Fixes: Auto Row Height Not Working

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 large 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 marge again just select the two cells and click Merge & Center from the Home Tab.

Here’s the final outlook.

Read More: How to Auto Adjust Row Height in Excel (3 Simple Ways)


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 (6 Methods)


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

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. 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

ExcelDemy
Logo