Excel Magic Trick #139: HYPERLINK function & Drop Down List

See how to use Data Validation List Drop-down and the hyperlink function to create a list of hyper links. See how to link to a web site or a cell on a different worksheet.

Category:

Science & Technology

Tags:

• Excel
• HYPERLINK
• function
• Data
• Validation
• Drop
• Down
• List
• link
• to
• cell
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[Sherlock69Holmes]

Its Awesome , In My scenario had to refer the sheets of workbook

But say , I had 100 sheets. i created list and a dropdown to select the link , & then hyerlink function as shown , its not working..

[ExcelIsFun]

@Sherlock69Holmes , I am sorry I do not know what is causing the problem. Try posting to:

mrexcel [dot] com/forum

[meranewid]

sir my email address is mrfuad2007@gmail.com ..

[ExcelIsFun]

@meranewid , if you are an educational site, yes! Don't embed if you are using videos for profit.

[chopinsiblos]

i mean drop down list with hyperlink in it and link it to, let say for example i have a dropdownlist with name 1 to name 5, name 1 wll link to sheet 2, name 2 linked to sheet 3 and so on...thank you for the rply...your tuts help me a lot...GodBless,more power!

[ExcelIsFun]

@chopinsiblos , like I said: when you Ctrl + K, then click on "Place In This Document" - that is how you link to a sheet.

[Sherlock69Holmes]

Plz Plz guide me Mike

[meranewid]

Question 1: Sir Please explain to me how can make multiple entries"non linkable URLs" in a colum a link able (mouse over , hand comes as Hyperlink is there) ? for one entry its very simple that we use to edit the cell and press enter "it becomes hyper link"

Question 2: its basically a viseversa of the above question that how we remove multiple hyper links if there are more than 4000 clickable URLs , for one URL its only to right click > remove hyper link but for 4000??

Plz plz plz help..

[meranewid]

very useful videos.. sir can i add (embed) your all videos from youtube channel to my website?