Share via

Excel Worksheet Hide/Unhide Tabs

Anonymous
2022-07-22T00:07:40+00:00

When I right-click to "Unhide" a tab, all hidden tabs from all workbook files appear in the popup window.

Can't tell which tab goes to which workbook.

??

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-22T03:45:35+00:00

    Hi,

    My apology for that..

    Have you check the link that I provided for other resolution with your issue like the one below?

    Click File > Options.

    Click the Microsoft Office Button then Excel Options.

    Then click Advanced > Display > clear or select the Show all windows in the Taskbar check box.

    Clarence

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-22T03:40:13+00:00

    Clarence,

    I don't believe your suggestion covers any part of my problem. Please carefully read my problem again, and see if you can replicate it in a couple of your own Excel workbooks/sheets.

    Branko

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-07-22T01:17:06+00:00

    Hi Nastyboy48,

    Thank you for posting your query. My name is Clarence, I'll be more than happy to assist you with your concern.

    To resolve your query kindly do the steps below.

    Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets.

    On the menu that appears, do one of the following:

    To hide the sheet, select Hide.

    To unhide hidden sheets, select them in the Unhide dialog that appears, and then select OK.

    Notes: To select multiple sheets do either of these:

    Press and hold CTRL, then click the items to select them.

    Press and hold SHIFT, then use the up and down arrow keys to adjust your selection.

    Go to this link for your reference and other troubleshooting procedure to resolve your issue https://support.microsoft.com/help/69f2701a-21f5-4186-87d7-341a8cf53344

    Do not hesitate to message us if you need further assistance.

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Best Regards,
    Clarence

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2022-07-22T04:01:43+00:00

    Hi,

    To answer your query "YES" it would provide you an unhide box section where you can choose which tab or worksheet would you like to unhide..

    I'll double check my resources here to be sure and get back to you immediately.

    Clarence

    0 comments
  5. Anonymous
    2022-07-22T03:45:39+00:00

    Clarence,

    Here's another way of presenting my problem.

    If I have an excel file that has 11 tabs of which none are hidden, and I right-click one of the tabs and click "unhide", should I see anything in the popup window?

    Branko

    0 comments