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.
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.
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.
Immediately after clicking on the ok button, we will find that the height of that row is increased.
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.
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.
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
Immediately after selecting Autofit Row Height, we can see that the height of row 4 is increased.
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.
Now we have to apply the keyboard shortcut ALTR + H + O + H (one after another) to open a message box having the initial row height.
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.
Here, we can see that immediately after clicking on the ok button, the height of row 4 is increased.
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.
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.
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.