How to create table of contents in Excel

TOC stands for Table of Contents. It is a one-click tool that creates a list of all worksheets in an Excel workbook 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:
    Select the top cell for your table of contents with hyperlinks in Excel.
  2. Click on the TOC icon in the Manage group on the Ablebits Data tab:
    Click the TOC icon to create table of contents in Excel.

    3. You'll get a list of all sheets you have in your Excel workbook as references:
    Insert table of contents in Excel.

Please contact us here

Our working hours:
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Central European Time (CET) 08:00 - 23:00
Eastern Time (ET) 2:00 AM – 5:00 PM
Central Time (CT) 1:00 AM – 4:00 PM
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Australian Eastern Daylight Time (AEDT) 6:00 PM – 9:00 AM (next day)
If you want to attach files (e.g. screenshots or log files), it will be possible right after you send this form and we automatically create a support ticket for you.