Forum Discussion

Deleted's avatar
Deleted
Jul 15, 2019

Impossible to find an existing table

Hi everyone,   I am working on an excel file with multiple tabs and tables. There is no more than one table per tab. Some table are data I have copy/paste, some others are tables that I have create...
excel
Formulas and Functions
nabilmourad's avatar
nabilmourad
MVP
Jul 15, 2019

Deleted 

Hi,

Let's differentiate between Sheet Tab names & Tables (who have names as well.

If you are looking at a Specific Table and you do not find it, you can see a list of All Tables by clicking on the Formulas Tab >> Name Manager (Shortcut CTRL + F3)

If you are looking at sheet tabs then you can do one of the foollowing:

1- To the far left side of the sheet tabs >> Right click on the Navigation buttons >> You get a List of All the  VISIBLE sheet Tabs >> double clicking on anyone of them >. will take you right there.

2- You can extract a list of ALL Sheet VISIBLE & HIDDEN in a new worksheet (and even create a 2 ways navigation), either by using Power Query or by Using VBA .

i explained that in 2 separate Tutorials , here are the links:
https://www.youtube.com/watch?v=jEr3uj1ljQ8

 

https://www.youtube.com/watch?v=V0KfbMZa_pY

 

You can also do it by using formulas and Functions which will only extract a List of the VISIBLE Sheets. Here is another Tutorial on how to do that:

https://www.youtube.com/watch?v=FeKgWSD8IWc

 

Hope that helps

Nabil Mourad

Resources