Building a Table of Contents in Google Sheets

 

Have you ever made a spreadsheet so large that you get lost in it? It is something that has happened to the best of us. While Google Sheets are a great format for recording and crunching data, they can be increasingly difficult to navigate the larger they get.

Wouldn’t it be cool if you could create a table of contents that would link you to the specific tab you needed info from? Tables of contents are usually associated with books or large documents but they can also be implemented in Sheets to make finding info much quicker. Although this is not a Google feature, with this workaround you can add a table of contents to all your multi-page spreadsheets.

Click here to watch this video on YouTube.

Get the best tips and tricks in your inbox daily