Much faster and more effective than the above 2 methods Quicker than Method 1 in case of multiple worksheetsĭemands you to list numbers and sheet names in advance Too tedious if there are too many worksheets
![creating hyperlinks in excel to another sheet creating hyperlinks in excel to another sheet](https://cdn.extendoffice.com/images/stories/doc-excel/ttw-modules/navigation-pane/ad-navigation-pane-book-sheet-0.png)
Then, put the code below into a project or module.
#CREATING HYPERLINKS IN EXCEL TO ANOTHER SHEET HOW TO#
At the outset, launch Excel VBA editor by referring to “ How to Run VBA Code in Your Excel“.Ultimately, drag the function down to get the hyperlinks to the other sheets.Later, put the formula below into Cell C1.Then, list all worksheet names according to the Method 2 in the post “ 3 Quick Ways to Get a List of All Worksheet Names in an Excel Workbook“.Now, you can insert the hyperlinks to the remaining sheets one by one.Finally, click “OK” to insert the hyperlink.Then, change “Text to display” to the sheet name.After that, in the list of “Or select a place in this document”, choose the first sheet except the current new sheet.
![creating hyperlinks in excel to another sheet creating hyperlinks in excel to another sheet](https://i.ytimg.com/vi/mf0GNWLtdX8/maxresdefault.jpg)
![creating hyperlinks in excel to another sheet creating hyperlinks in excel to another sheet](https://cdn.extendoffice.com/images/stories/doc-excel/hyperlink-to-workbook-sheet-cell/doc-hyperlink-workbook-sheet-cell-4.png)
If you have an Excel workbook which contains a great amount of worksheets, you may find it troublesome to locate and access your desired worksheet. In this article, we will share 3 methods with you. When an Excel workbook has many worksheets, in order to access them quickly, you may want to create a list of hyperlinks to all worksheets.