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.

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