Is there some reason you can't select say row 1 - 7029 and Format - Row -
Height and set it to 14.25?

"Scott Brooks" wrote:

Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are
hidden/have a 0 height. I learned from a previous post that I can
manually "drag" each row and change its height back to 14.25. Since
this is not my worksheet (a colleague asked me to "fix" it) I am loath
to manually drag 7000+ rows to the correct height. I have highlighted
the workbook, right clicked; change height to 14.25 and this only
changes the height of "visible" rows. Row 1 is frozen (with titles).
The numbers for rows 1181 to 1184 are blue.

This was created with MS Excel 2003 and I am using MS Excel 2007.

Thanks for any ideas and advice.