In this tutorial, we will show you exactly how to make a table of contents in Google Sheets in just a few simple steps. Simply follow the steps below.
Follow the steps below to make a table of contents in Google Sheets.
Add a new sheet for the table of contents by clicking the "+" icon at the bottom left of your screen, and rename it to "Table of Contents." This new sheet will serve as a centralized location for your links to other sheets.
Click on the first cell where you want to create a link in your table of contents. This cell will be where you add the link to the first sheet in your document.
Right-click on the selected cell and choose "Insert link."
In the dialog, select "Sheets and named ranges." This option allows you to create direct links to the sheets in your document.
Pick the sheet you want to link. This creates a hyperlink that allows users to jump directly to that sheet.
Click the next cell down, right-click, and choose "Insert link." Then select "Sheets and named ranges" to link each corresponding sheet in your table of contents.
Adjust the font style, size, and alignment to improve the appearance of your table of contents.
Click each link in your table of contents to confirm they direct you to the correct sheets.
We hope that you now have a better understanding of how to make a table of contents in Google Sheets. If you enjoyed this article, you might also like our articles on how to export a Notion table to Google Sheets and how to make a master sheet in Google Sheets.
