Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel ...

To create a table of contents manually, first decide where you want to place it. It's recommended to create a new worksheet for the table of contents to make it easier to locate and manage.

Show users how to create a quick table of contents in Excel using the power of hyperlinks. Hyperlinks have been around for a long time, but some Excel users just don’t use them.