locked
Drop down list with hyperlinks? RRS feed

  • Question

  • Is there a way to create a drop down list in excel 2010 that can contain individual hyperlinks or bookmarks to different sections within the worksheet?
    Tuesday, October 5, 2010 5:14 PM

Answers

  • Following Ron's suggestion:

    You can name merge cells so I don't understand the problem.

    To answer your original question - I don't believe you can have hyperlinks to the elements of any dropdown list.

    1. Select a cell and type a name into the Name Box, the box directly above column letters A and B.  (No spaces in names - there are other rules but if you stick to letters and numbers, no cell addresses, you should be fine)

    2. After you have named all the cells, click the drop down arrow on the name box and pick a name.  You should be taken to that location instantly.

    The benefit of this approach: 1. the list is always visible because you can open the Name Box from any cell on any sheet, 2. you don't need to place a control such as a drop down list or data validation list, in the spreadsheet.

    In your response you said "this doesn't work with merged cells =P", what does =P mean.  Range names should not start with an equal sign, if that's what you are trying to do.


    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire
    • Marked as answer by Sally Tang Monday, October 18, 2010 1:30 AM
    Sunday, October 17, 2010 4:34 AM

All replies

  • Why not keep it simple

    Give the cells you want to goto a name (use Ctrl F3 to open the name manager)

    Then you can press F5 and select the name you want to jump to



    Regards Ron de Bruin
    http://www.rondebruin.nl/tips.htm

    "mzymblo" wrote in message news:c34c9e0c-ab6a-448a-bdcc-85cc1ecae3ba@communitybridge.codeplex.com...

    Is there a way to create a drop down list in excel 2010 that can contain individual hyperlinks or bookmarks to different sections within the worksheet?

    • Proposed as answer by Gary's Student MVP Tuesday, October 5, 2010 10:28 PM
    • Marked as answer by Sally Tang Thursday, October 7, 2010 2:02 AM
    • Unmarked as answer by Sally Tang Thursday, October 7, 2010 2:02 AM
    Tuesday, October 5, 2010 8:06 PM
  • Why not keep it simple

    Give the cells you want to goto a name (use Ctrl F3 to open the name manager)

    Then you can press F5 and select the name you want to jump to



    Regards Ron de Bruin
    http://www.rondebruin.nl/tips.htm

    "mzymblo" wrote in message news:c34c9e0c-ab6a-448a-bdcc-85cc1ecae3ba@communitybridge.codeplex.com...

    Is there a way to create a drop down list in excel 2010 that can contain individual hyperlinks or bookmarks to different sections within the worksheet?


    Although sound advice, this doesn't seem to work with merged cells =P that part wasn't mentioned.
    Wednesday, October 6, 2010 1:29 PM
  • For development issue, you can ask the question in

    excel for developers forum:

    http://social.msdn.microsoft.com/Forums/en/exceldev/threads

    Best Regards,

    Sally Tang

     

    • Marked as answer by Sally Tang Friday, October 15, 2010 7:31 AM
    • Unmarked as answer by Sally Tang Friday, October 15, 2010 7:31 AM
    Friday, October 15, 2010 7:31 AM
  • Following Ron's suggestion:

    You can name merge cells so I don't understand the problem.

    To answer your original question - I don't believe you can have hyperlinks to the elements of any dropdown list.

    1. Select a cell and type a name into the Name Box, the box directly above column letters A and B.  (No spaces in names - there are other rules but if you stick to letters and numbers, no cell addresses, you should be fine)

    2. After you have named all the cells, click the drop down arrow on the name box and pick a name.  You should be taken to that location instantly.

    The benefit of this approach: 1. the list is always visible because you can open the Name Box from any cell on any sheet, 2. you don't need to place a control such as a drop down list or data validation list, in the spreadsheet.

    In your response you said "this doesn't work with merged cells =P", what does =P mean.  Range names should not start with an equal sign, if that's what you are trying to do.


    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire
    • Marked as answer by Sally Tang Monday, October 18, 2010 1:30 AM
    Sunday, October 17, 2010 4:34 AM