How to Create a Table of Contents with Hyperlinks in Excel

Рет қаралды 21,339

Күн бұрын

Пікірлер: 27

@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 7 ай бұрын

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 7 ай бұрын

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 3 ай бұрын

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

@SharonSmith 3 ай бұрын

Glad to help! Thanks for watching!

@ValentineDama 4 ай бұрын

Hi Sharon, Your video is very helpful to my work

@SharonSmith 4 ай бұрын

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

@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

@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.

@mshanika 2 ай бұрын

Thank you so much!❤

@SharonSmith 2 ай бұрын

Thanks for watching!

@spawnfh2116 11 ай бұрын

I absolutely love your videos🙏🏽

@SharonSmith 11 ай бұрын

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

@Sayan_93 7 ай бұрын

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 8 ай бұрын

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...

@catanainc 3 ай бұрын

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 2 ай бұрын

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!

@jandalbion1128 11 ай бұрын

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.