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.


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


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


<< Go Back to Row Height | Rows in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo