Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.