Missing rows that I cannot unhide

[squirt]

I have some rows missing (like they are hidden in my spreadsheet) it was previously shared, and now I cannot get to these missing rows. I have tried to unhide them, but that does not work. Any ideas?

 

[daniels012]

Not sure if this will work?
Can you change the view of the sheet??

Go to the menu bar View>Custom Views and see if they have a normal view or try to delete the views.

Michael

 

[squirt]

That did not work. I have no idea where this information went.

 

[goldfish]

Welcome to the forums.

So when you say they are hidden you see the rows are numbered 1,2,3,7,8,9.... or something like that where it skips a bunch? there is no chance someone deleted them?

If so there is a possibility that they are simply very small and not completely hidden. In this case highligh the concerned rows (or the rows surrounding the hidden rows) Then go
Format -> Row -> Height
and type 15 and enter. This should take care of the problem in either case if they're hidden or just very small.

~Gold Fish

 

[squirt]

Thank you. That did not work either.

 

[squirt]

That is the problem that i have it goes from row 318 to 352.

 

[Cindy Ellis]

squirt,
Is your worksheet filtered? (I know that's sort of obvious, but if it is, my suggestion wouldn't be useful at all). Filtering will hide rows that remain hidden when choosing Unhide Rows, because the filter is still applied. To turn off filtering, select the Data menu, then select Filter, and see if either autofilter or advanced filter has a check-mark by it. If so, un-check it, and your rows should return.
If that's not the solution...
Assuming that the worksheet isn't filtered, try selecting all of the rows&columns with data, extending past the missing cells, and paste into a new worksheet. You should at least be able to see what's there and what's not there, and may be able to re-construct the original sheet.
Hope that helps,
Cindy

 

[squirt]

Cindy, Thanks so much, you pointed me in the right direction.. The only thing i needed to do was "show all" THANK YOU. sometimes the obvious is the hardest thing to see. That is why we come to this site. THANKS to all I am sure that I will be back many more times.

 

[MrL777]

Update, 15 years later...
The situation was solved for me by Going to View>Freeze Panes> Unfreeze Panes

 

[adre]

Update, 15 years later...
The situation was solved for me by Going to View>Freeze Panes> Unfreeze Panes

Thanks for the update, even after 15 years! This was exactly what I needed.