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

Get FREE Advanced Excel Exercises with Solutions!

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


How to Increase Row Height in Excel: 4 Handy Ways

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


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. 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


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


Download Practice Book


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


<< 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.
Foyez Alam
Foyez Alam

FOYEZ ALAM is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Armed with a B.Sc in the Institute of Leather Engineering & Technology, University of Dhaka, he's shifted to become a content developer. In this role, he crafts technical content centred... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo