Tips: If there is no Developer tab in your ribbon, please read this article How to show/display developer tab in Excel 2007/2010/2013 Ribbon? to activate it.ģ. Click Developer > Insert > Combo Box, and drag the cursor to draw a combo box as you need. Second, create a combo box and format the control.Ģ. Give your hyperlinks list a range name “ Hyperlinks”, and name a blank cell “ Linked_cell” which is the linked cell of the combo box value into the Name Box, see screenshots: Please do as follows:įirst, please create two range names for your hyperlinks list and a linked cell.ġ. There is no direct way to create drop down list with activated hyperlinks in Excel, but, you can insert a formula to activate the selected hyperlink from the drop down list, please do as this:Īfter creating the drop down list, please enter this formula: =HYPERLINK(D2,"Go To Website!") ( D2 is the drop down list cell) in cell E2 which beside your drop down list cell, and press Enter key, then when you choose one URL hyperlink from the drop down list, and click the formula cell, the hyperlink will be opened.Īctually, you can also create a drop down list with hyperlinks by using combo box, and when you select a hyperlink from the combo box, it will be activated at once.
In Excel, adding drop down list may help us to solve our work efficiently and easily, but, have you ever tried to create drop down list with hyperlinks, when you choose the URL address from the drop down list, it will be open the hyperlink automatically? This article, I will talk about how to create drop down list with activated hyperlinks in Excel.Ĭreate drop down list with hyperlinks by using formulaĬreate drop down list with hyperlinks by using combo box
How to create drop down list with hyperlinks in Excel?
0 kommentar(er)
