How to Create Table of Contents in Google Sheets (Step-by-Step)

If you’re working with a lot of sheets in a Google spreadsheet document, you may want to create a table of contents of all the sheets. It would make it easier for users to jump to a specific sheet instead of navigating through many sheets in the tabs area.

While there is an in-built functionality to create a table of contents in Google Docs, it’s not there in Google Sheets.

However, it can still be done easily.

In this short tutorial, I will show you how to quickly create a table of contents in Google Sheets. You can create a TOC for different sheets in the document as well as the

So let’s get started!

Create Table of Content for All the Sheets in Google Sheets

Navigating through sheets could be really frustrating. If you need to do this often, it’s better to create a table of content of all (or specific) sheets that will help you go to that sheet instantly.

Below is an example of what can be created in Google Sheets.

Below are the steps to create a Table Of Content of sheets in Google Sheets:

  1. Right-click on the cell in which you want to create the link to a sheet
  2. Click on ‘Insert link’ (or use the keyboard shortcut Control + K)
  3. In the box that opens, click on the ‘Sheets in this spreadsheet’ option. It will show you a list of sheets in the document
  4. Click on the sheet to which you want to hyperlink the cell
  5. Click on Apply
  6. Do this for all the sheets that you want to include in the Table of Contents.

Once you have done this, you can instantly go to any sheet (which is a part of the TOC) by simply clicking on the cell and clicking on the link that appears at the top of it.

If you want to remove this link, right-click on the cell and then click on the ‘Unlink’ option.

Note: When you create a link to a sheet by following the above steps, it would replace the text in the cell with the HYPERLINK formula. In our example, the cell with the text West becomes =HYPERLINK(“#gid=937687704”,“West”). And when you remove the link by right-clicking and then clicking on Unlink, you will notice that while the link is gone, the formula remains. You will have to manually delete the formula and get the original text string back.

Create Table of Content for Specific Ranges in Google Sheets

You can also create a table of contents of specific cells or range in Google Sheets. These cells could be on the same sheet or in other sheets.

For example, in the below dataset, I can link the sales value in column B to the data in each sheet.

Dataset where individual cells need to be linked

This way, when I click on the cell in the sales column, it will take me to the sheet and select the data set that makes up the sales value in the Table of Content.

Range to get selected when you click on the link in the cell with number

Below are the steps to get a link to a cell or a range in Google Sheets:

  1. Right-click on the cell in which you want to insert the link to the data.
  2. Click on Insert link option (you can also use the keyboard shortcut Control + K)
  3. In the box that opens, click on the ‘Select a range of cells to link’ option. This will open the ‘Select a data range’ dialog box.Click on Select a range of cells to link
  4. Navigate to the sheet which has the cells that you want to link to. Then select the cell (or the range of cells). You would notice that the cell/range reference also gets specified in the dialog box.Navigate and select the range
  5. Click OK
  6. Click on Apply

The above steps would create a link in the cell and when you click on ṭhe cell and then click on the link that shows up, it will take you to that range for which you have created the hyperlink.

Note: You can only create a link to a contiguous range of cells.

Again, note that when you add a link using the above steps, it alters the cell content and add the HYPERLINK formula.

If you want to remove this link, right-click on the cell and then click on the ‘Unlink’ option.

So this is how you can create a Table of Contents in Google Sheets which can instantly take you to the specified sheet or cells/ranges.

Hope you found this tutorial useful!

Other Google Sheets tutorials you may like:

Leave a Comment