Cannot unhide several columns???

[JenniferMurphy]

I just encountered another weird condition that I cannot explain or correct. I have a sheet to track some medical conditions that I've used for years. I froze the cell, or the row, just below the table header so that I could scroll down and see the last row in the table and still see the headers. This morning, I noticed that rows 2-12 appear to be hidden. The row numbers in the left column go from 1 to 13. That is, the row after Row 1 is Row 13. But if I select the top few rows, the Unhide button is grayed out. Can anyone help me understand what I did and, more importantly, how to correct it?

 

[BradleyS]

Just for info it is not hide the workbook, it is hide the window and it is in the Window section, so in my opinion it is correctly labelled.
Do you not get a message telling you what it does when you hover your mouse over it (it is also the same button/icon you would have used to hide your personal workbook if you have one)?

Slighly pedantic in reference to my not calling it a "Window". When you unhide - it clearly states Workbook!
However, I accept your clarification.

 

[JenniferMurphy]

Slighly pedantic in reference to my not calling it a "Window". When you unhide - it clearly states Workbook!
However, I accept your clarification.
View attachment 123129

Yep, good point. Just another example of casual and imprecise language and user information.

 

[Peter_SSs]

Slighly pedantic in reference to my not calling it a "Window". When you unhide - it clearly states Workbook!

You are quite right but continuing with the overly pedantic approach, if you hover over the Unhide the pop-up says 'Unhide Window', so a bit of a mixed terminology there (but either way clearly nothing to do with columns or rows).
Also, in relation to the Hide hide button, again hovering shows 'Hide Window' and when clicked, no mention of Workbook. Also, clearly it is a window that is being hidden not a workbook since if you have two or more windows of the same workbook open, clicking Hide only hides that window, not the whole workbook.

 

[JenniferMurphy]

You are quite right but continuing with the overly pedantic approach, if you hover over the Unhide the pop-up says 'Unhide Window', so a bit of a mixed terminology there (but either way clearly nothing to do with columns or rows).
Also, in relation to the Hide hide button, again hovering shows 'Hide Window' and when clicked, no mention of Workbook. Also, clearly it is a window that is being hidden not a workbook since if you have two or more windows of the same workbook open, clicking Hide only hides that window, not the whole workbook.

And wouldn't it really be amazing if the geniuses at Microsoft did anything like that kind of analysis, testing, and debugging that is done here on this forum.

 

[MARK858]

Slighly pedantic

Not that pedantic as I said exactly the same to another member in a conversation yesterday, but as Peter said you can have multiple windows of the same workbook in the list, so it's definitely should say window (it shouldn't be workbook as you can for instance have 3 windows of the same workbook hidden and 2 windows of the same workbook unhidden at the same time).