Can't Unhide rows?

**Aland2929** · 06-10-2013, 12:38 AM

I am trying to unhide rows but the Unhide command is not allowing me to? I have selected the entire worksheet and highlighted the rows. Is there another way of unhiding rows?
Thanks in advance

**FDibbins** · 06-10-2013, 12:45 AM

do you have filters set?

Maybe they are not hidden, maybe they were made "0" height?
try to high-light a row above and a row below, right-click and set the row height to, say, 12

**Aland2929** · 06-10-2013, 12:49 AM

Thank you. Filters were set!

**FDibbins** · 06-10-2013, 12:52 AM

been there, done that

Happy to help

**AchiraSD** · 02-04-2016, 12:55 PM

OOOOps... FILTER , I waste about 1 hour to solve it..

Thnx a lot Bro..

**jostan** · 02-04-2016, 03:25 PM

been there, done that

Happy to help

**Nickjsky** · 05-23-2019, 03:38 PM

I know this is an old thread, but I just discovered another way that rows can become un-unhideable. If the page is scrolled up a little at the time that the Freeze Panes command is used (on the Ribbon under View>>Window>>Freeze Panes) then the rows that are off the top of the screen will be permanently hidden until the Unfreeze Panes command is used.