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

[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

 

[Bernard Liengme]

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

 

[Dave Peterson]

Any chance you're looking at filtered data?

Data|Filter|Show All

May help.

 

[Don Guillett]

Sub unhidecells()
With ActiveSheet
..Rows.Hidden = False
..Rows.AutoFit
..Columns.Hidden = False
..Columns.AutoFit
End With
End Sub

 

[Tyro]

Read a book on Excel?

Tyro

 

[Terri Chapman]

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.

 

[Terri Chapman]

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.

 

[alee]

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?