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

Get FREE Advanced Excel Exercises with Solutions!

Sometimes we need to adjust row heights in Excel to view cell contents properly. In this article, we’ll show you the simple methods to Auto adjust Row Height in Excel.

To help you understand better, I’m going to use a sample dataset as an example. The following dataset represents the Salesman, Product, and Net Sales of a company.

excel auto row height


Download Practice Workbook

Download the following workbook to practice by yourself.


3 Simple Ways in Excel to Auto Adjust Row Height

1. Excel AutoFit Row Height Feature to Auto Adjust Row Height

In our first method, we’ll use AutoFit Row Height feature in Excel to adjust the row height of Row 9 in the following image so that we can properly see the cell contents.

Excel AutoFit Row Height Feature to Auto Adjust Row Height

STEPS:

  • First of all, select the 9th.
  • Next, select the AutoFit Row Height feature in the Formats drop-down list which you’ll find in the Cells group under the Home tab.

Excel AutoFit Row Height Feature to Auto Adjust Row Height

  • Finally, you’ll see the newly adjusted 9th row.

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


2. Double-Clicking Lower Boundary for Auto Adjusting Row Height in Excel

Another way to auto-adjust row height in Excel is by Double-Clicking the mouse. Here, we’ll double-click the Lower Boundary of the 5th row to view the cell contents clearly.

Double-Clicking Lower Boundary for Auto Adjusting Row Height in Excel

STEPS:

  • First, point the mouse cursor at the lower boundary of the 5th row.

  • Finally, double-click the mouse and you’ll get your desired outcome.

Read More: Row Height Units in Excel: How to Change?


3. Auto-Adjust Row Height in Excel With Keyboard Shortcut

We can also apply Keyboard Shortcut to adjust row height in Excel. Follow the steps below to know how to use it.

STEPS:

  • Firstly, select the 10th row.

Auto-Adjust Row Height in Excel With Keyboard Shortcut

  • Next, press the keys ‘Alt’, ‘H’, ‘O’ and ‘A’ one after another.
  • Finally, it’ll return the newly adjusted 10th row.

Read More: How to Change & Restore Default Row Height in Excel


Other Ways to Adjust Row Height in Excel

1. Excel Row Height Feature for Adjusting Row Height

We can also manually set row heights in Excel with the Row Height feature.

STEPS:

  • First of all, select any row or multiple rows to adjust the height.
  • In this example, select all the rows from 4 to 10.

Excel Row Height Feature for Adjusting Row Height

  • Next, select the Row Height feature in the Formats drop-down list which you’ll find in the Cells group under the Home tab.

Excel Row Height Feature for Adjusting Row Height

  • A dialogue box will pop out and type your desired row height there.
  • Then, press OK.

  • Finally, you’ll see the selected rows with their newly adjusted height.

Read More: How to Copy Multiple Row Height in Excel (3 Quick Tricks)


2. Adjusting Row Height in Excel Using the Mouse

We can also use the Mouse to adjust row heights manually.

STEPS:

  • First, select rows 4 to 10.

Adjusting Row Height in Excel Using the Mouse

  • Next, click the mouse and drag the lower boundary of any of your selected rows.
  • In this example, select the lower boundary of row 6.

Adjusting Row Height in Excel Using the Mouse

  • Finally, you’ll get your required row heights.

Read More: How to Change the Row Height in Excel (7 Easy Ways)


3. Excel Wrap Text Feature to Adjust Row Height

We will apply the Excel Wrap Text feature in our last method to adjust row height. Here, our 4th row contains the title of the specific columns, but they are not properly placed within the cell.

Excel Wrap Text Feature to Adjust Row Height

STEPS:

  • First, select the cells B4, C4, and D4.
  • Then, select Wrap Text in the Alignment group under the Home tab.

  • Finally, you’ll see the re-adjusted 4th row.


Excel AutoFit is Not Functioning (Possible Reasons)

  • If you have Merged Cells, the AutoFit feature won’t work. You have to manually set the row height for such cases.
  • The AutoFit feature also won’t work if you have applied the Wrap Text feature in your cells. You have to manually set the row height for such cases.

Conclusion

Now you will be able to Auto adjust Row Height in Excel using the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung Shine

Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo