Share via

Missing sheet selection menu

Anonymous
2024-10-23T21:33:56+00:00

How do I add the three horizontal lines that show all of the sheets in my workbook? I have over 100 sheets and need this function to easily pick which sheet I want to go to. Currently there is nothing where it should be.

Microsoft 365 and Office | Excel | For business | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-24T02:06:48+00:00

    Use name range to get a worksheet list

    =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

    How to List All Sheet Names in Excel (With Example) (statology.org)

    Then use formula to create a list with 3 columns.

    =WRAPCOLS(GetSheetName,COUNTA(GetSheetName)/3)

    Image

    Then use hyperlink function to create hyperlink to each sheet.

    =HYPERLINK("#'"&B2&"'!A1",B2)

    Excel - Hyperlink to a worksheet which name is found in a cell - Super User

    Image

    Another way is to right click here to find the sheet you want to go.

    Image

    Was this answer helpful?

    0 comments