Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
When working with large workbooks in Microsoft Excel, you
can spend a good deal of time navigating through dozens of sheet name tabs to
find the one you need. One method for making this task easier is to build an
index sheet that contains hyperlinks to every worksheet in your workbook.
To create the index, follow these steps:
- Insert a new worksheet at the beginning of your
workbook and rename it Index. - Right-click on the sheet tab and select View
Code. - Enter the following code in Listing A.
- Press
[Alt][Q] and save the workbook.
The next time you open the workbook, the Index sheet will
contain a list of hyperlinks to each worksheet in the workbook. Each worksheet
also contains a hyperlink back to the Index sheet. In this example, the link
back to the Index is contained in cell H1, but it can be in any cell that is
blank for all worksheets.