unhide rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Wanna Learn

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

Mike Rogers
 
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?
 
Mike I tried that and it does not work

Mike Rogers said:
Wanna Learn

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

Mike Rogers
Click to expand...
 
Tim I tried that and it does not work

tim m said:
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?
Click to expand...
 
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!
 
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?
 
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
 
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
 
I am having the same problem in several spreadsheets. I have tried all the
solutions offered, and nothing is working. Any more ideas?
 
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.
 
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.....
 
Back
Top