Excel 2003 Lists and Hyper links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get Excel to display a dropdown list of Hyperlinks? I tried the
Validate command but did not get very far. Thank you in advance.
 
You probably have already found that referencing a list of hyperlinks in a
data validation drop-down produces only "cold" hyperlinks (not clickable).
However, say we put the dropdown in B1; in A1 enter:
=HYPERLINK(B1)

This will produce a nice, "hot", link in A1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying arrow in a dropdown list within cell 2
Need to have a dropdown list or allow other entry? 1
Validation dropdown list is not available 1
MULTIPLE ROW DROPDOWN LIST 4
How do i show the drop down arrow for a list in Excel 1
Creating .txt files based on cell contents 4
Data Validation Dropdown List Not Working 4
hyperlink from dropdown list 6

Back
Top