List All Worksheet Names with Hyperlinks as Table of Contents in Excel!!
Tags: kutoolsexceltutorial, listallworksheetname, kutools
Published: 2020-10-27 09:24:29

---
title: List All Worksheet Names with Hyperlinks as Table of Contents in Excel!!
published: true
date: 2020-10-23 10:31:56 UTC
tags: KutoolsExcelTutorial,ListAllWorksheetName,Kutools
canonical_url: https://geekexcel.com/list-all-worksheet-names-with-hyperlinks-as-table-of-contents-in-excel/
---

In this post, you will learn how to **List All Worksheet Names with Hyperlinks as Table of Contents of Workbook** in **Excel** Office 365 using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## To do:

We are going to use the **Create List of [Sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/) Names** option of Kutools to finish this task.

Using this utility, you can also do the below-given actions.

- Create a new worksheet that serves as the table of contents.
- List all sheet names as Sheet Index.
- Each sheet has been linked with a hyperlink for navigation between them.

Here, for example, we are going to build a worksheet index. To do this, follow the below steps.

- First, you need to **activate the workbook** that you want to create a worksheet index.
- Go to the **Kutools Plus Tab, select** the **Worksheet** option, **choose** the **Create List of Sheet Names** from the menu.

![Select the Create List of Sheet Names option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-27.png)<figcaption id="caption-attachment-16264">Select the Create List of Sheet Names option</figcaption>

- It will open the **Create List of Sheet Names Dialog box**.
- **Sheet Index Styles –** You need to select any of the options given in this section. You can create a sheet index with a hyperlink or macro button.
- **Specify sheet name for Sheet Index –** Give your sheet name as you need for your Sheet Index.
- **Insert the Sheet Index in –** You need to specify the position of the Sheet index using the given drop-down list.
- **Displaying Sheet Index into – ** Using this option, you can display the Sheet Index as 1 column, 2 columns, 3 columns, or 4 columns.

![Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Dialog-Box-1.png)<figcaption id="caption-attachment-16265">Dialog Box</figcaption>

- Then, **click** the **OK** button and you can see that a new worksheet with Sheet Index has been created as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-42.png)<figcaption id="caption-attachment-16266">Output</figcaption>

- If you **check** the **Contains buttons and [macros](https://geekexcel.com/vba-macros/)** option, you will get the output as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-36.png)<figcaption id="caption-attachment-16267">Result</figcaption>

## Closure:

In this post, you can easily understand the steps to **List All Worksheet Names with [Hyperlinks](https://geekexcel.com/quick-keyboard-shortcut-to-add-hyperlink-in-ms-excel-365/) as Table of Contents of Workbook** in **Excel** Office 365 using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Convert Days to Years, Months, and Days in Excel 365?](https://geekexcel.com/how-to-convert-days-to-years-months-and-days-in-excel-365/)
- [How to Select All Unlocked Cells in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-select-all-unlocked-cells-in-excel-office-365-with-example/)