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. Click on the TOC icon in the Manage group on the Ablebits Data tab:



3. Get a list of all sheets you have in your Excel workbook as references:

Related links

• How to manage your Excel workbooks
  
• Learn to manage columns in Excel
  
• Insert watermarks to Excel sheets