How to Resize All Rows in Excel (6 Different Approaches)

While working in Excel, we often need to adjust row size. There are many ways in Excel to resize all rows. In this article, I am going to discuss 6 methods in Excel to resize all rows. I hope this will help you manage the dataset you are working with well.


Download Practice Workbook

This is the worksheet that I am going to use to show all the methods in Excel to resize all rows. The datasheet includes some Subject Code along with the Subject Name and number of Students in these departments. You will certainly notice that Subject Code (cell B4), and the name of the subjects are not clearly visible. You need to do something in Excel to resize all rows.

Excel resize all rows

Similarly, in this image below, you can see that some rows ( for example, row 5 and row 7) are unnecessarily large. Here, you need to decrease the size of these rows to make the dataset tidy.

Excel resize all rows

So, you need to know how to both increase and decrease your dataset. With these two datasets, I am going to show you different methods that you can use in Excel to resize all rows.


6 Ways in Excel to Resize All Rows

1. Resize All Rows in Excel by Dragging

We can simply regulate all rows in Excel by dragging our mouse. To do so,
First of all, we need to select the rows that we are going to work with. For instance, in our case, we need to resize the rows from row 4 to row 10. So we selected that range. You can select all the rows as per your requirement.

Excel resize all rows

Then move your cursor to the left, move until the plus sign pops up.

Excel resize all rows

Then drag as per your requirement. Excel will change the row height.

Excel resize all rows

Note: For our case, it is sufficient to select from the 4th row to the 10th row. If you need to resize all the rows, you just have to select the entire rows.

Read More: How to Move Rows Down in Excel (6 Ways)


2. Resize All Rows in Excel to a Specific Height

In this section, I will describe how to both increase and decrease the rows in Excel to alter all rows.


2.1. Increase Row Size

You can increase row size in Excel to a certain height as per your requirement. For this,
First, select the rows you are working with. For instance, in our case, it is from row 5 to row 10.
Then,  go to Home tab >> select Cells >> select Format >> select Row Height

Row Height window will appear.

Put a height as per your need. For instance, I am going to put the height as 45 points.  Then click OK.

Excel resize all rows

Then, Excel will resize the rows.

Excel resize all rows


2.2. Decrease Row Size to Resize All Rows

Now we will learn how to decrease the row height. This is very simple and easy. To do so,
You have to select the range. For our case, it is from row 4 to row 10.


Then bring the Row Height window just like you did in section 2.1.
Put the Row height as 20 points. Then click OK.

Excel resize all rows

Excel will resize the rows.

Read More: How to Increase Excel Row Limit (Using Data Model)


3. Adjust All Rows in Excel by Double Click

In this method, I will show you another way in Excel to adjust all rows.
First, select the rows you are working with. For instance, in our case, it is from row 5 to row 10.
Then, bring the plus sign.
Then simply double click the left side of your mouse. Excel will resize the rows automatically.

Related Content: Unhide All Rows Not Working in Excel (5 Issues & Solutions)


Similar Readings


4. Regulate All Rows in Excel by Right Click

Interestingly, you can both increase and decrease row size by right clicking your mouse.


4.1. Increase Row Size

To increase row size,
First, select your dataset. In our case it is from row 4 to row 10.
Then, right click your mouse, the Context menu will pop up.
After that select Row Height.

Excel resize all rows

Row Height window will appear. Set Row height as 45 points. Click OK.

Excel resize all rows

Excel will resize the rows.


4.2. Decrease Row Size

In a similar way, you can also decrease row size. To do so,
First, select the dataset. Then, bring the Context menu.
From the Context menu, select Row Height.
Then put row height as you require. I have put the height as 20 points.

Excel resize all rows by right click

Excel will resize the rows.

Related Content: Shortcut to Unhide Rows in Excel (3 Different Methods)


5. Resize All Rows in Excel by AutoFit

You can directly AutoFit the row size in Excel. To do so,
First, select the rows you are working with. For instance, in our case it is from row 5 to row 10.
Then, go to the Home tab >> select Cells >> select Format >> select AutoFit Row Height.

Excel resize all rows

Excel will automatically resize the rows.

Excel resize all rows

Related Content: How to Lock Rows in Excel (6 Easy Methods)


6. Resize All Rows in Excel by Keyboard Shortcut

In Excel, to resize all rows, you can also use Keyboard Shortcut. To do so,
First, select your dataset. In our case it is from row 4 to row 10.
Then press the following on your keyboard, ALT + H, O, and A.
Excel will AutoFit the selected rows.

Excel resize all rows by keyboard

Note: Please note that you need to press the keyboard buttons sequentially, not altogether. First, select ALT and H together ALT + H, then press O and finally A.
A is for AutoFit. If you want to resize by changing Row Height, press H in spite of A.


Practice Workbook

It is easy to regulate row size in Excel. However, it is vital that you practice enough to master this skill. That’s why I have attached practice sheets for you so that you can practice the method you find most suitable.
This one is for practicing how to increase the row size to alter all rows.

Excel resize all rows Practice

This one is for practicing how to decrease the row to regulate all rows.


Conclusion

In this article, I have explained the methods to readjust row size. I tried to cover how to increase and decrease the row size. I hope this article will be helpful for you to learn how to readjust all rows in Excel. Lastly, if you have any comments, please leave that in the comment section.
Excel with us.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo