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 support@ablebits.com.
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.