How to unhide rows....when they won't unhide

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

I am having a repeated problem.

I receive files that has hidden rows. When I Rclick and select
unhide, they are still hidden. When I select Format, Row, Unhide,
they are still hidden.

The only way to unhide them seems to be to double click each
individual hidden row.

Does anyone know a better way to do this?

Am I completely missing something?

Thanks
 
Not sure how you double click a hidden row.
If rows 9 and 10 are hidden , I select the row headers 8 and 11, right click
and use Unhide.
Does this not work for you?
best wishes
 
Sub unhidecells()
With ActiveSheet
..Rows.Hidden = False
..Rows.AutoFit
..Columns.Hidden = False
..Columns.AutoFit
End With
End Sub
 
I ran into another wrinkle on this. I had hidden column A on a sheet and it would not unhide. Filtering and column width of zero weren't the problem either. Drive me crazy. Turned out once I unfroze the pane I had set I could Go To A1 and unhide co1. A.
 
I ran into another wrinkle on this. I had hidden column A on a sheet and it would not unhide. Filtering and column width of zero weren't the problem either. Drove me crazy. Turned out once I unfroze the pane I had set I could Go To A1 and unhide co1. A.
 
Old thread, I know, but I just experienced the same problem on rows 1-22. Found that if I click and drag down the row height above row 22 it showed row 1 again! Then I clicked and dragged the bottom of row 1 down and row 22 showed up. Then I highlighted 1and 22, and unhide worked like it should. Maybe we aren't supposed to hide row 1?
 
Back
Top