Share via

Can you search Tabs for a specific Tab Name?

Anonymous
2010-12-28T15:58:43+00:00

I have an Excel 2003 file that has about 50 tabs in it, all with unique names. I know data I am looking for is located on a certain tab but don't want to have to scroll through all 50 tabs to find that one tab.  Is there a way to search for a specific tab name? When I tried to search, I only got data in cell on worksheets that had that name.  Thanks!

Microsoft 365 and Office | Excel | For home | Windows

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

Answer accepted by question author

  1. Anonymous
    2010-12-28T16:06:13+00:00

    I have an Excel 2003 file that has about 50 tabs in it, all with unique names. I know data I am looking for is located on a certain tab but don't want to have to scroll through all 50 tabs to find that one tab.  Is there a way to search for a specific tab name? When I tried to search, I only got data in cell on worksheets that had that name.  Thanks!

    If the tab you want to find has the name "mytab", push F5 and enter mytab!A1 in the reference box. Click on OK and you will find yourself on the tab that you looked for.

    Hope this helps / Lars-Åke

    200+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-01-09T23:21:50+00:00

    Another way to find tabs relatively quickly is to Right-click on the MaxLeft arrow in the Tab line and a selection menu of tabs will pop-up

    Or, you can set up a menu sheet with links to each Tab.......

    hth

    Vaya con Dios,

    Chuck, CABGx3

    100+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-02-03T17:11:47+00:00

    Brilliant! it worked

    10+ people found this answer helpful.
    0 comments