+ Reply to Thread
Results 1 to 3 of 3

Hyperlink formula for multiple cells and/or ranges

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    6

    Arrow Hyperlink formula for multiple cells and/or ranges

    I would like to use the hyperlink formula to link to a range of cells in the same sheet.

    This should be simple and works when I press ctrl+K and enter A1:A2 for the cell reference; but not with the formula.

    =hyperlink(A1:A2,"Link to A1:A2")

    ALSO, if there's a way to hyperlink from one cell to multiple non-contiguous ranges that would be amazing!!! Something like pressing a hyperlinked cell A1 and selecting C1:C3 and E1:E3.

    Any help is much appreciated...

    Thanks,
    Dan
    Last edited by danj34; 06-09-2009 at 12:06 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: =hyperlink(A1:A2,"Link to A1:A2")

    Welcome to the forum, danj.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-08-2009
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    6

    Question Re: Hyperlink formula for multiple cells and/or ranges

    Thanks SHG.

    So is there anyone in this forum who can give me an answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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