Ask Experts Questions for FREE Help !
Ask
    yamentabbakh's Avatar
    yamentabbakh Posts: 1, Reputation: 1
    New Member
     
    #1

    Sep 17, 2011, 11:57 PM
    How I Can make an index sheet which has links to all other sheets in the workbook?
    I want to the other sheet to look like an hyperlinks in the first sheet !
    CliffARobinson's Avatar
    CliffARobinson Posts: 1,416, Reputation: 101
    Ultra Member
     
    #2

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    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.
    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Sheet Tab Links [ 2 Answers ]

Does anyone know if you can automatically link the name of the individual sheet tab name to a cell in the same sheet? In other words, if the sheet tab name is "Trains 09" I'd like to be able to have this title show up in a cell in the spreadsheet.

Link spread sheets sheet 1 to sheet 2 , 2 to sheet 3 [ 4 Answers ]

I have attach what I have done on the site. What I need to do is link all of the data from sheet one to sheet 2. All I have found so far is how to link one cell to the other cell. In sheet 1 I have af 3 to af 699 . I need to bring all that data to sheet 2 to (d3 to d24) Sheet 2 will link into...

XL only opens with sheet not workbook [ 1 Answers ]

All XL workbooks formerly saved only open in sheet format. When documents are copied and taken to another computer, all sheets of workbook are there. How can this be converted back to opening as a workbook?

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 [ 1 Answers ]

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 .


View more questions Search