How to unhide hidden rows and columns?

[Jyggalag]

Hi all,

This may seem super simple and silly to ask, but I have currently made this setup:

I have hidden EVERYTHING except for rows and column 1-7.

However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and click "Unhide", nothing happens.

Anybody got an idea on how to get past this?

Thank you!

 

[Anthony47]

Press F5 (GoTo), insert A10 as the destination, press Ok; press Shift and use the mouse to select row 7 (by clicking on the "7" at the far left of the window) to extend the selection up to Row 7.
Now if you rightclick on the number of the rows the option Unhide should be available for you

 

[Peter_SSs]

Another option: In the name box type 8:10 ..

.. then press Enter
Now you can unhide the rows ..

 

[Jyggalag]

Another option: In the name box type 8:10 ..

View attachment 66585

.. then press Enter
Now you can unhide the rows ..

View attachment 66586

Thank you both for your responses!

This solution seems simplest though, so I used that. Thank you very much Peter, it is much appreciated

Kind regards,
Jyggalag

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.