Table of Contents – Yup! It’s Possible in Google Sheets

0
113
table of content in Google Sheets

Can I create a Table of Contents in Google Sheets? If this is your question, my answer is “Yes”. You can create Table of Contents in Google Sheets.

Table of Content is the possibly easiest to way to tell the reader where a specific page resides in a book. So the reader can easily navigate to that specific content page. In a printed book, the page number is important. So it can see alongside the table of content items.

But when we think digitally, instead of page numbers, our table of content should have link to the corresponding pages. Page number is not relevant here.

It’s easy to prepare a table of content in document writers such as Word, Google Doc etc. It’s an essential part of it and inbuilt. Then what about preparing a Table of Contents in Google Sheets?

If we use some logic, it’s possible to prepare a similar table of content in Google Sheets too. Now here we are sharing the idea – How to prepare a table of content with links in Google Sheets?

table of content in Google Sheets

Steps to Create Table of Contents in Google Sheets:

First prepare your table of contents in a sheet. Refer the below sample.

  A B C
1 T A B L E    O F   C O N T E N T S    
2 1. Combine Text+Text, Text+Date & Text+Number
3 2. Heard About the Very Useful “Function Numbers”?
4 3. Yes! We Can Use Subscript & Superscript Numbers.
5 4. Table of Contents – Yup! It’s Possible in Google Sheets

 

Now our first topic in the table of content is “1. Combine Text+Text, Text+Date & Text+Number”

Now what we want to do is go to that specific sheet where the detail related to the first topic is lying. It may be in another sheet or same sheet. We consider the detail is in a new sheet tab. So go to the very first cell in that sheet. Right click and click on Get link to this cell. This’s linking cell feature in Google Sheets. You can see the message The link has been copied to the clipboard.

Now come back to our Table of Content sheet. Go to Cell A2 and right click to see the menu options. Click Insert link. Against the link label, paste the link we’ve just copied and click Apply.

Repeat the step to complete linking other titles. That’s all. Your table of content in Google sheet is ready.

This Google Sheet trick you can use in different scenarios like jump to different sheets, different cells etc. I earlier used similar table of content in an invoice sheet, where my first sheet was index page and link to measurement sheets in different pages.

If you enjoy this new Google Sheet trick, please share with your friends and of course we value your comments below.

LEAVE A REPLY

Please enter your comment!
Please enter your name here