View Full Version : How do I create an index sheet in Excel that links to other tabs?
ChuckP1967
Oct 11, 2011, 12:17 PM
In excel I have a workbook with multi tabs at the bottom, I want to make a sheet in the same workbook that would have a cell to link each tab to the front page. Kind of like an index page that would have a link to each tab..
JBeaucaire
Oct 12, 2011, 12:54 AM
CREATE A HYPERLINKED LIST OF SHEETS IN A WORKBOOK ON A FRONT SHEET
This macro creates a "table of contents" on a sheet at the beginning of the workbook. Each sheet listed is also an active Hyperlink so click the name will take you directly to the sheet. Put a link on all your other sheets back to this front sheet and you have an extremely fast navigation system for large workbooks. There's a sample file for you to see this operate.
Create Hyperlinked List of Sheets (https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/search-functions/hyperlink-sheets)
Once the hyperlinks are created for you, you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.
evelynm
Oct 16, 2011, 06:41 PM
Creating links to every sheet tab in a index page may be a simple operation if you use an application Kutools for Excel. It is a Excel add-ons collection that can help avoid the repetitive operations in Excel. I don't mind using macro to create links, but when there is a tool available, why not choose and try it? Very easy to use and do help save much time.
JBeaucaire
Oct 17, 2011, 01:11 PM
I don't mind using macro to create links, but when there is a tool available, why not choose and try it?
Because it's not free. When you can do it yourself or get someone to help you do it yourself, why not do it yourself?