View Full Version : How I Can make an index sheet which has links to all other sheets in the workbook?
yamentabbakh
Sep 17, 2011, 11:57 PM
I want to the other sheet to look like an hyperlinks in the first sheet !
CliffARobinson
Sep 18, 2011, 12:16 AM
You want a list of the other sheets to be hyperlinked, so when you click on them it takes you to that sheet?
JBeaucaire
Sep 20, 2011, 10:21 PM
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, if there are a LOT of links you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.