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.

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 the Subject Code (cell B4), and the names of the subjects are not clearly visible. You need to do something in Excel to resize all rows.

Similarly, in the 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.

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.

How to Resize All Rows in Excel: 6 Approaches

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

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

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

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.

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.

Then, Excel will resize the rows.

Read More: How to Expand and Collapse Rows in Excel

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. In 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 will resize the rows.

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.

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.

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

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 will resize the rows.

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 will automatically resize the rows.

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.

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

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

Download Practice Workbook

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 them in the comment section with us.

Related Articles

• How to Color Alternate Rows in Excel
• How to Create Collapsible Rows in Excel
• How to Expand or Collapse Rows with Plus Sign in Excel
• How to Create Rows within a Cell in Excel
• How to Copy Every Nth Row in Excel
• How to Number Rows in Excel
• How to Lock Rows in Excel

<< Go Back to Rows in Excel | Learn Excel