How to Increase Row Height in Excel (Top 4 Methods)

A worksheet in Excel has cells that are cleanly arranged into rows and columns, where the default row height is 15 points and the default column width is 8 points. When you first start dealing with data in Excel, one of the first things you’ll notice is that you’ll need to change the row height sometimes based on your data (or adjust the column width). It’s a straightforward process, and I’ll show you four different ways to increase row height in Excel in this short Excel lesson.

Here, we took an Excel Sheet, where columns B, C, and D represent Name, Month, and Purchase respectively. We will increase the row heights in this Excel sheet by using several methods.

row height excel


Download Practice Book


4 Ways to Increase Row Height in Excel

1. Increase Row Height in Excel by Clicking and Dragging

This one is the easiest way to increase its height in Excel. For this, first, you have to select the row you want to increase its height. Here we select row 2.

Now take the cursor at the bottom of the row bar. And wait for that drag sign to come.

When the drag sign appears, just on it and drag down until you get your desired row height.

This is how just by clicking and dragging down, we can easily increase the row height.

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


2. Increase Row Height in Excel by Using Row Height Option

This is another one of the easiest ways to increase the row height in Excel. For this, we can select either the whole row or any cell of that particular row.

Like here we select cell C5 first which means we want to increase the row height of row 5. 

  • Open the Home tab >> go to Cells >> from Format >> select Row Height

Then there appears a message box having the default row height of 15 points.

Now, we have to put any value bigger than 15 to increase the height of that particular row 5. Let‘s type 25, click on the OK button and wait for the magic.

increase row height in excel

Immediately after clicking on the ok button, we will find that the height of that row is increased.

increase row height in excel

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


3. Increase Row Height in Excel by Using AutoFit Row Height

We will use this method in those cases where we need to resize multiple rows according to their font size. Here we can see that row 4 has an unusual less height than other rows and we need to increase its height. We can easily fix it by using AutoFitting method.

increase row height in excel

For this, we need to bring our cursor to the intersecting point of rows and columns. When we click on it, all the cells of the Excel Sheet are selected automatically.

increase row height in excel

Now just like the previous method, we have to follow some easy steps.

  • Open the Home tab >> go to Cells >> go to Format >> select AutoFit Row Height

increase row height in excel

Immediately after selecting Autofit Row Height, we can see that the height of row 4 is increased.

increase row height in excel

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


4. Increase Row Height by Using Keyboard Shortcut “ALTR + H + O + H”

To increase the height of rows in Excel, we can use a cool method like a keyboard shortcut. It is not only cool but also more convenient to some extent than other methods.

For this, we have to select a row first. Like here, we want to increase the height of row 4. Therefore, we select row 4.

increase row height in excelNow we have to apply the keyboard shortcut ALTR + H + O + H (one after another) to open a message box having the initial row height.

increase row height in excel

After that, we need to put any bigger value than the initial row height point. Here, we choose 25 points. Now, we will click on the OK button and the magic will be happened by itself.

row height excel

Here, we can see that immediately after clicking on the ok button, the height of row 4 is increased.

row height excel

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


Things to Remember

To increase the row height in Excel, you do not need to select all the rows at the same time. If you even select only one cell from your desired row, after applying the methods it will work for all other cells in that particular row.


Recommendation

I’ve given a practice sheet in the workbook to practice these explained ways to increase row height in Excel. You can download it from the link given above.

row height excel


Conclusion

In this article, I have tried to explain 4 different ways to increase row height in Excel. Note that, you can also decrease row height in Excel by just following the same methods. Last but not least, I will be extremely grateful if you comment down below any of your suggestions, ideas, or feedback.


Related Articles

Foyez

Foyez

Hello everyone, This is Foyez Alam. I have recently completed my MBA from Institute of Business Administration (IBA), University of Dhaka. Earlier I have completed my B.Sc in Leather Engineering from University of Dhaka. Now I am working as an Excel and VBA Content Developer in SOFTEKO. Through patience and hard work, I have a passion for learning new things and applying my knowledge to new situations. That's why I am here. Besides this, I love to interact with different people and I love to spend my spare time reading, watching movies, dancing, etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo