Auto fit row height

[Fountain]

Having selected a number of rows, selecting 'Auto fit row height ' only
operates on the majority of rows reducing them to 11.25 yet some remain at
22.5. I have checked each cell in the 22.5 row and there is only one row of
font eight text. Any suggestions please?

 

[Gord Dibben]

Any chance there are some merged cells in the rows that won't autofit?

If so, unmerge them.

Merged cells prevent row autofit.

You need VBA code to make it happen.

Are there possible some extra spaces in the cells?

What do you get when, in an adjacent cell, you enter =LEN(cellref)

Does the number look right?


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Or do you have any hidden columns with text that needs a higher row.

If these suggestions don't help, maybe you can explain in detail what you did.