Excel Hidden Rows, not hidden, may row height?
Posted on 2011-03-04
I have a shared 97-2003 Excel Workbook ( I am using Excel 2010). All of sudden several rows are "hidden".
When viewng the row numbers, they skip
1) Select unhide all rows - no luck
2) Select all rows and did row height - no luck
3) Select all rows and did auto height - no luck
What does work:
1) If I put my cursor right on the top of row 85, it changes to double bars (height adjustment) and I can pull down row 84. Then go to top of 84, do the same for 83.
These "hidden" rows are spread out throughout the worksheet, I would like a command to correct this.