During one my recent training programs, a participant asked an interesting question.
I have a list of values. I would like to place a hyperlink in my workbook that would always take me to the last value in the list.
Something like this,
Now, we all know that you can use HYPERLINK() function to create a hyperlink in Excel. Here is a detailed tutorial on hyperlinks in Excel.
But, how do we make the hyperlink dynamic?
Very simple, we just count how many values our list has and then link to the last cell’s address accordingly. See this video tutorial to understand how you can do it.
Dynamic Hyperlinks in Excel – Video Tutorial
Download Example Workbook on Dynamic Hyperlinks
Click here to download this example workbook. Play with it to understand how this technique works.
Do you use Hyperlinks? Share your tips
I use hyperlinks in my Excel workbooks all the time. They are easy to create and they make my workbooks more accessible. Adding a hyperlink is the easiest way to impress your audience.
What about you? Do you use hyperlinks? What are your favorite uses / tips? Please share using comments.
More Tutorials on Hyperlinks in Excel
Check out these tutorials to learn more about Hyperlinks in Excel
- Introduction to Excel Hyperlinks
- Creating a Table of Contents in Excel Workbook (and other tips)
- Creating a Birthday Reminder using Excel
- What is a Picture Link & How to use it?
PS: that is my hand-writing in the image above. I bought Genius Slim Tablet on my way back from Singapore. So I am playing with it.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Sumproduct function to Consolidate Revenues?||Details about our Financial Modeling Class »|