How to create table of contents in Excel

TOC stands for Table of Contents; it is a simple one-click tool that creates a list of all worksheets in an Excel book with hyperlinks to them. Here are the simple steps to use it:

  1. Select the top cell for the table of contents in your Excel spreadsheet:
  2. Select the top cell for your table of contents with hyperlinks in Excel.

  3. Click on the TOC icon in the Manage group on the Ablebits Data tab:
  4. Click the TOC icon to create table of contents in Excel.

  5. Get a list of all sheets you have in your Excel workbook as references:
  6. Insert table of contents in Excel.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.