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:
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
2. Select Sheets and named ranges
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
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
5. If you click on any of the links in your table of contents, it will bring you to the sheet
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.
2. Select Sheets and names ranges
3. Click on Select a range of cells to link
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
5. Repeat this process for any other ranges that you want to create a table of contents link for
6. If you want to rename the links, however over one of your links and select the Edit link option
7. From here you can replace the text of the link to be anything you want
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