I am unable to unhide rows through the format menu.

[Pistol]

I have tried unhiding rows and my worksheet is not protected and the panes
are not frozen. I have also tried selecting the entire worksheet to unhide,
but I wasn't able to see all of my hidden rows.

 

[David Biddulph]

Select a range including the rows in question (select the whole sheet, if in
doubt), and use Format/ Row/ Height to ensure that you don't have a zero or
small height set.

 

[Mike H]

Hi,

If the sheet isn't protected select everything by clicking the box in the
upper left corner at the intersection of the row and column headings then
click
Format|Row|Unhide

If that doesn't work check if the rows are hidden with a Filter. If they are
you can't simply unhide then you must remove the filter.

Mike

 

[Gord Dibben]

Maybe the sheet is filtered with the filter arrows set to not show?

Maybe the hidden rows are ust set to a very low height?


Gord Dibben MS Excel MVP

 

[Victoriamarie]

Mike,

I tried your suggestions, but I am still not able to unhide my Row 1. I'm
unsure of the filtering. As far as I can tell this row is not filtered. Any
other suggestions?

 

[Dave Peterson]

Maybe the row is off the visible screen.

Window|unfreeze panes (xl2003 menus)
and then scroll up

 

[Victoriamarie]

Thank you. Thank you. Thank you. I did have everything below Row 6 frozen. I
unfroze the sheet and then went to Format Row Unhide and my Row 1 showed up.
Any suggestions as to why freezing panes would cause this situation?

 

[Dave Peterson]

If you freeze the screen so that row 2 is visible and row 1 is off the screen
(hidden or visible), you won't be able to scroll up to see row 1.

As soon as you unfreeze the panes, you could scroll up to see if row 1 was
visible. If it isn't, you can use the other techniques to show that row.