How to Create a Table of Contents in Google Sheets

Inserting Table of Contents can be useful if you have a lot of content and you want to quickly skip to relevant sections. If you have used word processors such as MS Word or Google Docs, you would find an easy way to insert the table of contents.

But what if you want to insert a table of contents in Google Sheets?

There is no inbuilt way to do this, but you can use the workaround shown here to get that done.

Let me first show you the data and the kind of table of contents we can create in Google Sheets.

Suppose you have the data shown below, and you want to create a table of content for each sheet. So you want to make each sheet name in the below data clickable, such that when clicked, Google Sheets takes you to that sheet.

Creating a Table of Contents in Google Sheets - Demo

Here are the steps to create Table of Contents in Google Sheets:

  • Select the cell in which you want to create the hyperlink.
  • Go to the Insert Tab.Insert tab to create table of contents in Google Sheets
  • Click on the Link option.Create link in Google Sheets
  • In the dialog box that opens, click on ‘Sheets in this spreadsheet’.Select Sheets in this spreadsheet
  • Select the sheet to which you want to create the hyperlink.Select Q1 from the drop down in Google Sheets
  • Click on Apply.Use the Apply Button now

Now you need to repeat the same steps for all the cells for which you need to create the hyperlinks.

When you use this technique to create hyperlinks to sheets with the same document, you would notice that the content of the cell changes. From the text in the cell, it changes to the Hyperlink formula. If you need the text back, you need to manually change it in the cell (right-clicking and select Unkink would remove the link, but the cell content would still be the Hyperlink formula).

You May Also Like the Following Google Sheets Tutorials:


10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.