Autofit Height of Rows too High

[Kris]

My rows don't auto adjust to the height of the text, they all stay about
three times higher than they should be. I've tried row - format - autofit but
has no effect. Aside from manually adjusting them am I missing something?
Thanks,

 

[Ron@Buy]

Try: Format Cells > Alignment > Top then autofit again
This has woked for me in the past.

 

[Kris]

Thanks Ron, I tried that but the only way I get the rows to shrink is when I
take wrap text off.

Even when all columns are long enough to accomodate the text on one line the
rows stay too high.

Double clicking the row bottom doesn't change them either.

The only thing I changed that started this was converting to the
INDIRECT(..) function in the cells instead of direct references.