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!
Table of Contents
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:
- Right-click on the cell in which you want to create the link to a sheet
- Click on ‘Insert link’ (or use the keyboard shortcut Control + K)
- In the box that opens, click on the ‘Sheets in this spreadsheet’ option. It will show you a list of sheets in the document
- Click on the sheet to which you want to hyperlink the cell
- Click on Apply
- 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.
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.
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.
Below are the steps to get a link to a cell or a range in Google Sheets:
- Right-click on the cell in which you want to insert the link to the data.
- Click on Insert link option (you can also use the keyboard shortcut Control + K)
- 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.
- 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.
- Click OK
- 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:
