troubleshooting Question

Setting up a TOC / Index in Excel with absolute references

Avatar of Dot Glindemann
Dot GlindemannFlag for Australia asked on
Microsoft OfficeMicrosoft ExcelGolang
7 Comments4 Solutions166 ViewsLast Modified:
Hi, I am trying to set up an Index / Table of contents in an Excel File with fixed or absolute references. When I use the insert hyperlink function and fix my references using $ when I go back later they have disappeared. I have tried using contextures but while it works it does not have the option to rename it like you can with a hyperlink. I need the links to move when the cell moves when I add or delete rows etc.  The link I have used is =HYPERLINK("#'"&E2&"'!D2") I have attached the sample I have been working with. Any assistance would be greatly appreciated. Thanks Dot
Sample-Register.xlsx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 4 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros