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.

Table of Contents hide

Download Practice Workbook

2 Excel Fixes: Auto Row Height Not Working

1. Manually Input Row Height or Unmerge Cells

Download Practice Workbook

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

Auto Row Height Not Working.xlsm

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.

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

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.

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.

Type a large row height than the present height.

Later, just press OK.

Now the cell is fitted perfectly.

The second way is to unmerge the merged cells.

Select the cell and then click as follows to unmerge: Home > Merge & Center > 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.

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.

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.

Select the Macro Name as specified in the above codes.

Finally, press Run.

Now the cell is fitted with the text properly.

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.