Formatting Issues

Excel Maximum Row Height: Why the Limit Is 409 Points

Steve KSteve K Nov 18, 2026 868 views

Question details

Understand Excel's maximum row height and find ways to display content that needs more vertical space.

Excel Maximum Row Height: Why the Limit Is 409 Points
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to make an Excel row taller than 409 points to fit content.
Observed behavior
Excel limits a single row to 409 points, approximately 14.43 centimeters.
Before you start

Select the affected row and check its current height under Home > Format > Row Height. Decide whether the content needs to remain in worksheet cells or can be displayed in a text box.

Solution 1Recommended

Use multiple rows to create more vertical space

Split content across adjacent rows when it needs to remain in worksheet cells.

Excel's maximum height for a single row is 409 points. Formatting and VBA cannot raise this built-in limit, but multiple rows can provide more space together.

1
Add rows

Select a row heading near the content, then right-click and choose Insert to add rows as needed.

2
Split the content

Move or copy portions of the content into cells in the adjacent rows.

3
Adjust the row heights

Select the row headings, then choose Home > Format > Row Height and enter a height of 409 points or less.

4
Check the layout

Use Home > Wrap Text for cells containing long text, and review the result in File > Print if the sheet will be printed.

Use multiple rows to create more vertical space
About merged cells: Merging cells across rows can create a larger display area, but it does not increase the height limit of any individual row. AutoFit may not work as expected with merged cells.
Free Microsoft Office alternative

Work with spreadsheet layouts in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working on spreadsheet layouts. Open compatible Excel files, adjust rows, and use text boxes as you move between office applications.

Adjust rows and use text boxes to arrange spreadsheet contentCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can VBA increase Excel's maximum row height?

No. The 409-point maximum is a built-in Excel limit, so VBA cannot set an individual row above it.

How tall is 409 points in centimeters?

It is approximately 14.43 centimeters. In Excel, select the row and choose Home > Format > Row Height to view or change its height in points.

Does merging cells let a row exceed 409 points?

No. Merging cells across several rows can create a larger display area, but each individual row remains subject to the 409-point limit.

What can I do if wrapped text still does not fit?

Split the text across cells in multiple rows, or choose Insert > Text Box and place the text in a box that spans several rows.