SOLVED

Excel - unhiding multiple rows at top of worksheet

Copper Contributor

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

5 Replies
best response confirmed by Dawn2024 (Copper Contributor)
Solution

@Dawn2024 Hello, did you try selecting in the top (corner):

samarmesto_0-1706505351614.png

and after, right-click in one of the rows (maybe number 1) and unhide?

samarmesto_1-1706505438797.png

I hope it can be useful.

Thank you Mark - does this have to be done 1000 times? Oh bother!

@Dawn2024 

As variant

You may enter into name box

image.png

to selected first 1000 hidden rows. After that

Home->Format->Hide&Unhide->Unhide Rows

image.png

or use shortcut Ctrl+Shift+(

Don't remember 2013, perhaps details could be slightly different.

@Dawn2024 

Hi Dawn. Did you succeed in unhiding? I've tried all the answers but no luck. I have a worksheet which begins with row 181 and no way to get to lesser cells.

I am too embarassed to tell the community!! There was a filter on! Dinosaur!@joe90231 

1 best response

Accepted Solutions
best response confirmed by Dawn2024 (Copper Contributor)
Solution

@Dawn2024 Hello, did you try selecting in the top (corner):

samarmesto_0-1706505351614.png

and after, right-click in one of the rows (maybe number 1) and unhide?

samarmesto_1-1706505438797.png

I hope it can be useful.

View solution in original post