Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using the HYPERLINK function and finding it reliably useful. I'd value being able to assign hyperlinks (somehow) to individual menu drop downs.

share|improve this question
    
not sure what menu dropdowns are. Do you mean a dropdown combobox? – datatoo Apr 25 '11 at 16:02

Let me assume that you are talking about a drop-down via Data Validation.

As you cannot have both formula and value in the same Excel cell, you need to have another cell to build the hyperlink.

Let suppose you have your drop-down menu on column A.
You can put the formula in column B, something like:

=HYPERLINK([path]&A1,A1)
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .