Dec 15 2021 01:33 AM
Hi,
Does anyone know if there is a height limit on rows in Excel?
In my sheet it stops when the indicator shows: Height: 409,50 (546 pixels)
and I would like o have it a bit higher to fit my text in to the cell fitted in the print out page.
Dec 15 2021 01:48 AM
SolutionThat is the limit - see Excel specifications and limits. There is no way to increase it.
You'll have to make the column wider if you want to fit the text in the cell, or turn on "Shrink to fit" in the Alignment tab of the Format Cells dialog.
Dec 15 2021 01:49 AM
Change the column width and row height
TypeMinMaxDefault
Column | 0 (hidden) | 255 | 8.43 |
Row | 0 (hidden) | 409 | 15.00 |
Hope I could help you with these information / links.
Aug 15 2023 12:15 PM
You can insert a row below the maxed out row and merge the cells. That will allow you to exceed the 409 Height limitation and make your text fit in the cell without widening the column.
Dec 15 2021 01:48 AM
SolutionThat is the limit - see Excel specifications and limits. There is no way to increase it.
You'll have to make the column wider if you want to fit the text in the cell, or turn on "Shrink to fit" in the Alignment tab of the Format Cells dialog.