+ Reply to Thread
Results 1 to 7 of 7

basic hyperlink function

  1. #1
    Registered User
    Join Date
    03-17-2008
    Posts
    11

    basic hyperlink function

    How do I use the hyperlink function so the hyperlink goes to another page in the same excel document?

    For example, I want the hyperlink in sheet one to take me to sheet 2. How do I do this using the hyperlink function?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello bobflu,

    To Create a Hyperlink within the Workbook

    1. Right Click the cell you want the hyperlink in.
    2. At the bottom of the pop up menu click Hyperlink...
    3. On the left side of the Hyperlink Dialog you will see a column labeld Link to:
    4. Click on Place in this Document
    5. To the right, type the cell address to hyperlink to in the box labeled Type the cell reference:
    6. In the list box below, select the Sheet
    7. Click OK

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    03-17-2008
    Posts
    11
    Hey,
    is there any way of doing this using the hyperlink function? because i want the hyperlink change as data in a drop down list changes.
    Example: Cell contains 1,2,3,4 and 5 in a drop down list. If cell one is selected the hyperlink will be different from 2,3,4 and 5. All different data has their own unique hyperlink.

    I was thinking of using the IF function along with the HYPERLINK function to get this done.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,495
    Quote Originally Posted by bobflu
    Hey,
    is there any way of doing this using the hyperlink function? because i want the hyperlink change as data in a drop down list changes.
    Example: Cell contains 1,2,3,4 and 5 in a drop down list. If cell one is selected the hyperlink will be different from 2,3,4 and 5. All different data has their own unique hyperlink.

    I was thinking of using the IF function along with the HYPERLINK function to get this done.
    Try The indirect aproach
    =HYPERLINK("#"&CELL("address",INDIRECT("M"&A1)), B2)
    A1 is the drop down menu
    M is the column
    B2 is the text the hyperlink shows

  5. #5
    Registered User
    Join Date
    03-17-2008
    Posts
    11
    Thanks.

    But its not exactly what im looking for. I should have said earlier.

    Is there any way of having each item in the drop down list as text, link to a different page on the spreadsheet?

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,495
    Quote Originally Posted by bobflu
    Thanks.

    But its not exactly what im looking for. I should have said earlier.

    Is there any way of having each item in the drop down list as text, link to a different page on the spreadsheet?
    Maybe this thread will help you out,
    http://www.excelforum.com/showthread.php?t=636602

  7. #7
    Registered User
    Join Date
    03-17-2008
    Posts
    11
    Thanks a lot, I got it

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1