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

Thread: Linking to a row or colum, not a cell

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Richardson, TX
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know haw to hyperlink to a row in another sheet so that it will highlight the entire row? And on top of that, is it possible to set it up so that when it takes you to that row, it is in the center of the page?
    Bryan

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Bryan,

    When you click the Hyperlink icon after saving your workbook, you can specify what worksheet and row and column to link to

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Richardson, TX
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Brian, but when i do that, it asks for the "cell" reference, and i want it to go to the entire row, not just a cell in that row. Any ideas?
    Bryan

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Bryan,

    Give a range i.e. A1:D1

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Richardson, TX
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business.
    Bryan

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-26 09:59, Bryan James wrote:
    That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business.
    Hot and Sunny

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can just use 10:10 for an entire row.

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
  •