Maximum Row Height

Occasional Visitor

I am unable to drag my row height past 14.45 cm. I have tried using different views besides page layout, but the problem persists. If I try changing the row height using: Home -> Cells -> Format ->Row Height and I put in "14.5 cm" (546 pixels). Then, I get the following warning "The specified row height is too large. Specify a smaller value."

I can't seem to find much discussion on this online. I am using the row height to break up the pages based on the amount of content on each page (using macros to specify the row height). I know if I open a blank excel sheet, then I can change row height to whatever I want, but would anyone happen to know what could be limiting my row height?

1 Reply

@DexterGette 

This is a built-in hard limit - see Excel specifications and limits:

S1695.png

409 points corresponds to 546 pixels/14.45 cm