unhide rows

[Wanna Learn]

Hello
This only happens in one worksheet. I hid rows and cannot unhide them I
tried unhide rows, edit go to format row unhide, I even tried ungroup rows
and nothing works what did I miss? thanks

 

[Mike Rogers]

Wanna Learn

Select the rows on each side of the hidden row/rows and right click and
select unhide.

Mike Rogers

 

[tim m]

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

 

[Wanna Learn]

Mike I tried that and it does not work

Wanna Learn

Select the rows on each side of the hidden row/rows and right click and
select unhide.

Mike Rogers

 

[Wanna Learn]

Tim I tried that and it does not work

Perhaps you have some cells merged or something like that?

Have you tried left clicking on the sheet in the spot kitty corner to 1 and
A to select the whole sheet and then format cells unhide rows?

 

[bj]

How did you hide them?

Tim I tried that and it does not work

 

[BoniM]

Try selecting the range that includes the hidden rows and choose Format,
rows, autofit. If a row accidently gets sized as something other than zero,
then unhide won't bring it back.
Good luck!

 

[Wanna Learn]

Bj This is a monthly report so I really do not remember, but there is a
pivot table on the sheet could that have something to do with it?

 

[Wanna Learn]

Hi Everyone

I was able to unhide the rows one at a time. nothing unusual I did have a
sort on one of the columns . Again thank you

 

[Mike Rogers]

Wanna Learn

Another way that works for me is in the upper left corner find & select the
small square at the intersection of the columns and rows. Bring your curser
on the row side and right click select "Row Height" and enter something like
12.75. (If you put your curser over a colum e.g. A, B, C.... you can adjust
the column width.) This should bring everything selected to that row height.

Mike Rogers

 

[HannaS]

I am having the same problem in several spreadsheets. I have tried all the
solutions offered, and nothing is working. Any more ideas?

 

[Dave Peterson]

I don't know waht all the solutions were, but if you've tried autofitting the
rows, maybe you just can't see the rows you want.

I'd try window|Unfreeze panes
then scroll a few times.

 

[HannaS]

Thank you so much for all your suggestions. I have to confess, though, that
I have been a complete idiot, but have now solved the problem! Just in case
anyone else has done what I did, I will just ask one question: have you got
any filters applied? Enough said, I think! Oops.....