Excel Row Height Limit: What Is It and How to Extend It

Get FREE Advanced Excel Exercises with Solutions!

By default, you can set Excel row height from 0 to 409. However, you may need to set a much higher row height in many situations. In this article, we will describe how you can set Excel row height beyond the default limit.
In the GIF below, you can see that we cannot set the row height to 410 although we need it. After that, we will describe how you can get rid of this.

Overview GIF for Excel Row Height Limit


Excel Row Height Limit

Here, we will describe the default Excel row height limit. In Excel, we can set the row height from 0 to 409. Therefore, when you will set the Row height to more than 409, it will return a warning.

  • To set the row height to a maximum of 410, select a row.
  • Here, we select Row 5.
  • After that, go to the Home tab >> select Cells >> select Format.
  • Then, select Row Height.

Use the Home tab to select the Row height

  • At this point, a Row Height dialog box will appear.
  • Then, we will type 410 in the Row height dialog box.
  • Afterward, click OK.

Setting Row height in the Row Height dialog box

  • At this point, a warning will appear.
  • Hence, row height cannot be set to 410 or any higher values.
  • Furthermore, in the following article, we will describe how you can set an Excel row height limit of more than 409.

A warning showing row height cannot be set to 410.

Read More: Is There Any Way to Increase Excel Row Limit?


Row Height Limit in Excel: How to Extend?

In the following dataset, you can see the Job Titles. Here, using this dataset we will describe 3 easy steps to set the Excel row height limit. Here, we used Excel 365. You can use any available Excel version.

Dataset to set Excel Row height limit


Step-1: Setting a Row Height to 409.5

In this step, we will set the Row Height to 409.5.

  • To do so, we will follow the earlier steps to bring out the Row Height dialog box.
  • Then, we will set the Row height as 409.5 >> click OK.

Setting Row Height to 409.5

  • Therefore, you can see the expanded Row 5.

Expanded Row 5 height


Step-2: Inserting a New Row

In this step, we will insert a new row under the expanded row.

  • Therefore, first, we will right-click on Row 6.
  • Then, we will select Insert from the Context Menu.

Inserting another row

  • Therefore, you can see Row 6 has been expanded like Row 5.

Row 6 with the same Row height as Row 5

  • After that, we will make Row 6 height much shorter since we do not need that much larger rows.
  • After that, we follow the earlier steps to bring out the Row height dialog box.
  • Therefore, we set the Row height of 30 in the Row height dialog box.
  • Here, you can set the Row height according to your needs.
  • In addition, click OK.

Setting Row height for Row 6 to 30

  • Therefore, you can see the expanded Row 6.

Expanded Row 6


Step-3: Merging Rows to Extend Row Height Limit in Excel

In this step, we will merge the rows to extend the Excel row height limit. Here, we want the row height to become 439.5. Therefore, we will merge Row 5 and Row 6.

  • In the beginning, we will select rows 5 and 6.
  • After that, we will go to the Home tab >> then from the Alignment group >> select Merge & Center.
  • In addition, select Merge & Center.

Employing Merge and Center option

  • Therefore, the rows will be merged, and you will get an expanded row height beyond the default row height limit.

Merged rows


Practice Section

You can download the Excel file and practice the explained methods.

Practice Section


Download Practice Workbook

You can download the Excel file from the following link and practice while reading this article.


Conclusion

Here, we show you 3 easy steps for extending the Excel row height limit. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section.


Related Articles

Tags:

Afia Kona
Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

2 Comments
  1. This was very helpful! Thank you!

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo