Forum Discussion
Excel - unhiding multiple rows at top of worksheet
Hi there,
Can anyone assist me in an easy solution to unhiding about 1000 rows of data in an excel spreadsheet (2013). They are at the top of the worksheet.
I have no idea how they were hidden, and I have looked at all the online tutorials but am not successful in resolving this issue.
Many thanks
Dawn2024 Hello, did you try selecting in the top (corner):
and after, right-click in one of the rows (maybe number 1) and unhide?
I hope it can be useful.
Dawn2024 Hello, did you try selecting in the top (corner):
and after, right-click in one of the rows (maybe number 1) and unhide?
I hope it can be useful.
- Thank you Mark - does this have to be done 1000 times? Oh bother!
As variant
You may enter into name box
to selected first 1000 hidden rows. After that
Home->Format->Hide&Unhide->Unhide Rows
or use shortcut Ctrl+Shift+(
Don't remember 2013, perhaps details could be slightly different.
