Create an Index Page (TOC) with Clickable Links to All Sheets...

Automatically generate a clickable index page (Table of Contents, TOC) that links to your workbook's worksheets and chart sheets.
This tool creates a new worksheet listing all sheet names with hyperlinks for quick navigation. It acts as a TOC-style menu for your workbook, making it easier to move between sheets, especially in large files with many sheets.

Features & Benefits:

• Creates a Table of Contents (TOC) sheet with links to all sheets.
• Adds a return link to the index page for easy navigation.
• Supports both worksheets and chart sheets.
• Helps manage large workbooks more efficiently.

Quick Return to the Index Page:
To quickly go back to the index sheet, ASAP Utilities adds a named reference (___INDEX_SHEET___ASAP_Utilities) to your workbook. You can return to the index page anytime by selecting this name from the Name Box in the formula bar.

Note:
Since Excel does not support hyperlinks to chart sheets, ASAP Utilities uses a macro-based workaround to create clickable links. If your workbook contains chart sheets and is opened by someone without ASAP Utilities, clicking on a chart sheet link may result in a missing macro error.

Starting this tool

Additional keywords to help you find this tool:
Excel Table of Contents sheet, Create an index page in Excel, Clickable links to all sheets, Excel TOC with sheet hyperlinks, Sheet index with links, Create TOC for sheets, Automatically link all sheets, Excel sheet navigation menu, Excel tool to list all sheets with links, How do I create a Table of Contents for worksheets in Excel?, Is there a shortcut to build an index with links to all sheets in Excel?

Tip:Alt+P for the previous tool.