Search
Close this search box.

Easy Guide to Building a Google Sheets Table of Contents

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 Google Sheets table of contents. You can create a TOC for different sheets in the document as well as the

So let’s get started!

When to Use a Google Sheets Table of Contents

A table of contents sheet can help yourself others quickly find the information they need when you have several sheets in your spreadsheet file. You can build a table of contents for all of your sheets or just for specific ranges.

Create Table of Contents in Google Sheets for Each Sheet

Google Sheets table of contents GIF demonstration

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.

How to Make a Table of Contents in Google Sheets for Specific Ranges

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 adds the HYPERLINK formula.

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

How to Add a Table of Contents in Google Sheets FAQ

Can You Make a Table of Contents in Google Sheets?

Yes, you can make a table of contents in Google Sheets, but you must do so manually by adding hyperlink menu items.

How Do You Make a Clickable Table of Contents in Google Sheets?

You can make a clickable table of contents in Google Sheets by following these steps:

  1. Right-click an empty cell
  2. Navigate to Insert link > Sheets and named ranges
  3. Select the sheet to add
  4. Repeat steps 1-3 until you have all sheets or ranges you want to add to the TOC

How Do I Edit a Table of Contents in Google Sheets?

You just have to delete the items you don’t want by using backspace and add more by using the methods discussed in this article. If you’re seeing a warning that prevents you from making edits, the file owner likely protected that range.

What Should a Table of Contents Look Like?

That’s really up to you. You can use formatting to make the cells look better. The one rule you should stick to is to have the items in order. It’s also not a bad idea to make ranges within each page into subitems in the contents.

Building a Table of Contents Google Sheets Page

So this is how you can create a Google Sheets table of contents 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:

Most Popular Posts

1 thought on “Easy Guide to Building a Google Sheets Table of Contents”

  1. Greetings! Thank you for your article! Would you be so kind to tell me whether it is possible to create a link that updates automatically? I need to create a table of content for a page in a sheet that has 200+ rows. The table itself will be edited by different people and some chapters might be expanded by adding new rows. In that case, if I create a link to a cell (f.e. B76 with the words “Chapter 3”) and then add new rows before the 76th row – the link will still direct me to B76, while the cell with words “Chapter 3” is in 89th row (B89). Is it any way to solve this issue?

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.

Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.

Like what we do? Share this article!