Drop Down List of Hyperlinks - Excel Hyperlinks Tip

In this video, we create a drop-down list of hyperlinks to other sheets in the workbook.

I have created videos in the past on the HYPERLINK function and creating dynamic links from text on the worksheet.

In this video, though it is selected from a dropdown. A great idea for a report, table of contents or dashboard page. Where space is limited but you want simple and dynamic ways to navigate.

For this to work, we got smart we some Excel formulas using the INDIRECT and ADDRESS functions.

Here are the video timings.
00:00 - Introduction
00:59 - Create the drop-down list
01:38 - Explanation of our approach
02:53 - Sample link in the drop-down
03:37 - INDIRECT function to hyperlink to another sheet
06:58 - Demonstrate the completed drop-down hyperlink list

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[teoxengineer]

So interesting and magic. Indirect is so wonderful function and if it is improved with new features, it will be more accurately usable and functional.
Thank you Alan for explaining us these hidden indirect and link properties together

[kalidmomen]

I really wish I saw this vid sooner. I've searched everywhere to find this and here it is. All thanks to you, you're such a great life-saver . ❤Love all the way from Somalia.

[vusalhuseynov]

Thorough explanation! Thank you very much.

[chawkibouderbala]

Awesome !!! I made many lists by category and used it as a "web style" drop down menu lists, so usefull when whe have a lot of tabs ..👍

[jimfitch]

Very clever, Alan! I’m going to have to watch this again ... maybe more than once. 🥴 I’ve seldom used ADDRESS & INDIRECT, but it’s clearly time to go to school on these functions. I think I’ll be able to make good use of drop-down hyperlinks. Thanks for teaching it!

[patrickschardt]

Very informative. I’ll be implementing this in my testing reports. I test the same unit in multiple ways and each sheet is its own data set taken at different dates and times. Having a cover page with this will be very helpful

[deviguragai]

Thanks a lot sir. Your video helped me a lot at work.

[hassanalshekha]

Thank you sir...Much appreciated helpful sharing.

[GeorgeAJululian]

Thank you This is really a great video!

[sasavienne]

Thank you Alan. That is useful as usual. Salim..

[elh]

You helped me SO MUCH! THANK YOU! I subscribed :)

[sprptvy]

Thank you for this video! Can you show one doing this with Google sheets? I am having trouble getting the hyperlink to stick.

[ezelkarlkl]

thank you very much for this video. How can we use for Column B not only B1

[omars]

Great video as always. Can you have a drop down list where the options can link to opening and sending an email?

[zahir]

Lovely to watch your videos and continue learning. Keep it up ✌🏻

[Azam_Khan]

Awesome tutorial 😊👌
Could you please let us know how do we implement the same function in multiple cells.
I tried it in multiple cells, however, I am not able to figure out a way to implement it in multiple cells.

[mohideenthassim]

Many thanks Alan great tip. Also have great festive season and a happy new year 2020. Cheers Mohideen

[rohitharathnaweera]

Hi!

Great video!
Please advise how to clear web addresses appearing in the drop down list of "Insert hyperlink > Existing file or web page > Current folder > address: (drop down)" ?

[biancagarcia]

Would you be able to do another tutorial hyperlinking to the same tab rather than other tabs? And using the match formula instead of 1 for row number?

[gunfiresmoke]

how do i use the address and count function to jump down to a different row number