SOLVED

Row height limit?

Copper Contributor

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.

5 Replies
best response confirmed by OleDahl (Copper Contributor)
Solution

@OleDahl 

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

@OleDahl 

 

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.

@NikolinoDE
Thanks, I was not aware of these limits.
@Hans Vogelaar
Thanks, I was not aware of these limits.

@OleDahl 

 

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.

1 best response

Accepted Solutions
best response confirmed by OleDahl (Copper Contributor)
Solution

@OleDahl 

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

View solution in original post