Skip to Content

How to Create a Table of Contents in Google Sheets

There may be times when working in Google Sheets that you want to create a table of contents to make it easier to navigate through different tabs.

There is not a built-in way to do this, however, it can still be done.

In this tutorial, I will show you how to create a table of contents in Google Sheets.

Table of Contents

Creating a Table of Contents for Sheets

If you want to create a table of contents that contains links that you can click on to navigate to a particular sheet, that is pretty easy to set up.

In this example, I will be creating a table of contents that will link to 4 different sheets that all contain different sales data:

Table of Contents example

Here are the steps:

1. Right-click on the first cell where you want to insert the table of contents link and select Insert link. You can also press CTRL + K on your keyboard

Table of Contents-1

2. Select Sheets and named ranges

Table of Contents-2

3. You should now see a list of all the sheets available. Select the sheet that you want in your table of contents. Repeat these steps for every sheet

Table of Contents-3

4. After you have selected all the sheets you want in your table of contents, you should now see them all like in the image below

Table of Contents-4

5. If you click on any of the links in your table of contents, it will bring you to the sheet

Table of Contents-5

Creating a Table of Contents for Ranges of Data

Instead of creating a table of contents that leads to different sheets, you can also create a table of contents that will navigate to different ranges within a sheet.

The process is very similar to the previous method.

Here are the steps:

1. Right-click in the first cell where you want to place the table of contents link and select Insert link. You can also press CTRL+K on your keyboard.

Table of contents-range-1

2. Select Sheets and names ranges

Table of contents-range-2

3. Click on Select a range of cells to link

Table of contents-range-3

4. You can either manually type in the range that you want to link to, or you can highlight your range. Click OK when you are done

Table of contents-range-4

5. Repeat this process for any other ranges that you want to create a table of contents link for

Table of contents-range-5

6. If you want to rename the links, however over one of your links and select the Edit link option

Table of contents-range-6

7. From here you can replace the text of the link to be anything you want

Table of contents-range-7

Closing Thoughts

As your spreadsheets become larger and larger, keeping organized with a table of contents can be a good idea. This can make it easier to navigate to the particular sheet or range of data that you want to work with.

For most datasets, this can be set up in a matter of minutes through the insert link option.

Be sure to watch the video at the top of the page if you still need help figuring out how to do this.

More Google Sheets Tutorials:
How to Create a Unique List of Data Across Multiple Ranges