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?

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

On Wed, 20 Jan 2010 15:14:02 -0800, Fountain
wrote:

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?

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.

Fountain wrote:

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?

--

Dave Peterson