How to Create a Table of Contents with Hyperlinks in Excel

[@SharonSmith]

If you want to follow along with this video, you can access the worksheet I created in this video as an example for free. No need to share your email to access this file: drive.google.com/drive/folders/1tZsrkCtdUHkvFZ5vfYpoBFTPefY1F-sZ?usp=sharing Thanks for watching!

[@CarlRandle-rr3bg]

Sharon, this is one of my favorite Excel "how-to" videos. I found this easy to follow, with a good pace and examples. I was able to implement it on one of my more important worksheets, so excited to add this to my list of skills!!!

[@SharonSmith]

I’m so glad to hear that! Thanks so much for taking time to leave a nice comment, I really appreciate it! Thanks for watching!

[@syedqaisarabbas5904]

I always download your videos to improve my work.

[@SharonSmith]

That is great to hear! Thanks for supporting my Channel!

[@robertmeidinger6116]

Super helpful Sharon!! Thank you so much for this video.

[@SharonSmith]

Glad to help! Thanks for watching!

[@ValentineDama]

Hi Sharon, Your video is very helpful to my work

[@SharonSmith]

I'm so glad to hear that! Thank you for watching my videos!

[@mshanika]

Thank you so much!❤

[@SharonSmith]

Thanks for watching!

[@spawnfh2116]

I absolutely love your videos🙏🏽

[@SharonSmith]

I'm so glad you find my videos helpful! Thanks for watching!

[@rinaldodelucca8073]

Excellent video, thank you very much! Is there any way for adding the go back link automatically to all sheets? I have almost 6,000 sheets in one file and I really need to create the go back link in an automatic way.

[@teoxengineer]

Sharon hi, thank this good tutorial. I wanna learn about how can we use hyperlink with dropdown list? For example, I want to set up a drop-down cell and insert a sheet name list in it so that when I select a sheet name, I jump to the selected sheet in the workbook. Can we do it? Thanks

[@danielmpinga4102]

Nice 👏🏾👏🏾👏🏾

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@braddundas1127]

Hello Sharon! Your Excel videos are very helpful! I use Excel to manage my invoices that I send to clients. I keep a summary page where I put the job name, date, and total amount charged from each invoice. Is there an easy way to pull this data from all my sheets? I work in the same document and create a new tab for each invoice. As of now I'm doing it all manually and it's a bit of a pain.

[@farestahamohamed835]

Nice

[@SharonSmith]

Thanks so much for watching!

[@catanainc]

Any way to mass add the link to the TOC page? What if I have 500 sheets for example, how do I add a link to all of them?

[@SharonSmith]

Thank you for your question! If you have a large number of sheets (like 500), manually adding a hyperlink to each sheet would be very time-consuming. However, you can automate the process using a simple VBA macro to add the link to every sheet in your workbook. Here’s a basic macro that can help: Press Alt + F11 to open the VBA Editor. In the editor, go to Insert > Module to insert a new module. Paste the following code into the module: Sub AddHyperlinkToTOC() Dim ws As Worksheet Dim TOCSheet As String TOCSheet = "MasterSheet" ' Replace with the actual name of your TOC sheet For Each ws In ThisWorkbook.Worksheets If ws.Name TOCSheet Then ws.Hyperlinks.Add Anchor:=ws.Range("A1"), Address:="", SubAddress:= _ "'" & TOCSheet & "'!A1", TextToDisplay:="Go to TOC" End If Next ws End Sub Replace "MasterSheet" with the exact name of your TOC page. Press F5 to run the macro. This macro will add a hyperlink labeled “Go to TOC” in cell A1 of every sheet, except for the TOC sheet itself. If you need the link in a different location, you can change the cell reference in the code (e.g., change ws.Range("A1") to another cell). I hope this helps! Thanks for watching!

[@Sayan_93]

Super helpful. Also I wanna filter hyperlinks from another table because when I am using filter function only the names are shown, not the links. I have tried so many things but it’s not working and I have to see the filter result and go back to the table to find out the hyperlink. Please help.

[@bradleywooten830]

Perhaps it's my relative newness to digging into these sort of topics in Excel or my lack of understanding how Onedrive works, but can you say a little more as to why one has to pause OneDrive auto-synch and turn off auto save to perform this function? Thanks...

[@jandalbion1128]

Hello can you tell me how i can make a table of contents for only 1 tab in exel? So the table needs to refer to the start of a chapter on a row. Depending on adding new information the location of the row can/will change regularly.

[@syedqaisarabbas5904]

Hello how are you Sharron good evening I just want to tell u today I hv achieved 10 years long service award.

[@SharonSmith]

Congratulations! I'm so happy for you. 🙌 Thanks for watching my videos!