If the dialog can’t display the complete list, Excel will add a scroll bar to the right. Even if you must scroll through dozens of sheets, it’s still quick. Hyperlinks are a type of shortcut ...

That’s it! Now you have clickable links that will take you directly to the corresponding sheets when clicked. Another way to manually add a table of contents in Excel is by using the Hyperlink ...