MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Rows

Posted by Cheryl on May 09, 2001 1:11 PM

I have a spreadsheet that has been forwarded to me. It looks like there are hidden rows, but "unhide" does nothing and I don't see any signs of this spreadsheet being password protected.

Any ideas?

Posted by Dave Hawley on May 09, 2001 1:21 PM

Hi Cheryl

Sounds like they may just be set to a very small height. Push Ctrl+A then go to Format>Rows>Height as set to 12.75

OzGrid Business Applications

Posted by Cheryl on May 09, 2001 2:23 PM

Dave, Thanks for quick response. Unfortunately I had already tried that. No luck.

Posted by Ian G on May 10, 2001 12:21 AM

Hi Cheryl
Have you tried selecting the rows either side of the hidden rows and double clicking at the edge of the selection? This shouldn't do anything different to what Dave has suggested, but worth a try?
Ian G

Posted by Anon on May 10, 2001 4:08 AM

Has "Freeze Panes" been activated? And if so, what rows "look like" they are hidden? - the first row or rows?