+ Reply to Thread
Results 1 to 4 of 4

Hyperlink opens at bottom of worksheet

  1. #1
    Registered User
    Join Date
    11-12-2007
    Posts
    2

    Hyperlink opens at bottom of worksheet

    I have hyperlinks in my workbook that take me to specific parts of my worksheet. However, when I do this it opens the link in the bottom of the spreadsheet and not at the top. Is there any way to change my settings to allow hyperlinks open in the top of the worksheet?

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    Try putting a bookmark in the cell you want the hyperlink to jump to, then change the hyperlink to find the bookmark.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    11-12-2007
    Posts
    2
    When I place the bookmark and then jump to it using the hyperlink , it still displays the cell at the bottom left corner of the worksheet.

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    Sorry, I don't have any other suggestions.

+ 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