Hide/Unhide worksheets based on Index

**w20tong** · 10-09-2009, 09:44 AM

Hi,

This has bothered me for a long time!

I have 100 or even more tabs in one spreadsheet. I want to create an index page to make things easier when try to find the tab(s) I need. For example, I have 100 lines in the sheet1 (the Index); each name is matched to one of the tabs. If I clicked on one name, only the tab with that name would show up, and automatically hided all other tabs.

Also, is it possible to select multi-tabs at the same time? Eg. if I selected A1, A4 and A89 at the same time in the sheet1, I would like to see these 3 sheets, and others were hidden.

Thank you very much! Your help is highly appreciated.

**Rick_Stanich** · 10-09-2009, 04:01 PM

To get you started on some path, you can use hyperlinks to link to specfic sheets.
Right click a cell, select "Hyperlink". Once the dialog box comes up, then at the left side select "Place in this document", under "cell reference" select a worksheet.