Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: how do you hyperlink to different rows in the same document

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anybody tell me how you can create a hyperlink of somekind in Cell A200 that allows the user to go from row 200 back to row 5?

  2. #2
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To go cell A200 and select Insert/Hyperlink (or press control+k).

    When the dialog box comes up, you will have several choices of what to link to on the left-hand side of it. Choose "Place in this document."

    In the box "text to display," type "Go back to A5" or whatever you want.

    In the box "type the cell reference," just enter "A5" (without the quotes.)

    Click OK, then you've got a hyperlink!

    Hope this helps!
    Kristy

    _________________
    "What am I, a magnet for these idiots?"
    --Pearl Forrester, MST3K

    [ This Message was edited by: Von Pookie on 2002-03-18 14:02 ]

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeppers, we like hyperlinks....

    also, if A5 is a named range, you can specify the name range in the hyperlink (sometimes easier to remember than the actual cell reference)

    ie "Summary_Heading" or "start_cell" if you have lots of hyperlinks all over the place that point back to it
    :: Pharma Z - Family drugstore ::

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Funnily enough I needed to know how to do this as well, but am having trouble labelling the hyperlink. I press CTRL + K and I dont get the option of TEXT TO DISPLAY so my hyperlink is called "SheetA1!"

    Why is this?

  5. #5
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-19 06:06, Audiojoe wrote:
    Funnily enough I needed to know how to do this as well, but am having trouble labelling the hyperlink. I press CTRL + K and I dont get the option of TEXT TO DISPLAY so my hyperlink is called "SheetA1!"

    Why is this?
    Sorry, I forgot to mention that I am using Excel 2000. I can't remember how it works exactly on 97 (if that's what you're using).

    Anyone else care to chime in on this one?
    Kristy

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Oregon
    Posts
    130
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah, Excel 97 is WAY basic compared to 2000 when it comes to hyperlinks. But, really, all you have to do is type your label in the cell where you want the link before you make the link. It'll take whatever's in there as the link label.

    Then, under "Named location in file," you can just type in the cell where you want to go.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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