+ Reply to Thread
Results 1 to 6 of 6

bookmarks on a worksheet?

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    Nigeria
    Posts
    17

    bookmarks on a worksheet?

    Hello friends!,

    I have a worksheet that has a fairly large amount of data, grouped by state. I want to be able to access certain points along my table using shortcuts or bookmarks.

    To be specific, i want to be able to go from A1 to,say A150, and from there to A450 and back to A1(Back To Top, or something like that), like you can do in web pages.

    As always, any help will be greatly appreciated.
    Last edited by byronova; 09-17-2009 at 04:04 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,406

    Re: bookmarks on a worksheet?

    Hi,

    You could add hyperlinks to cells in your sheet.

    Right click a cell, select Hyperlink, place in this document,

    enter a cell reference.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: bookmarks on a worksheet?

    or you can Name your respective cells (eg select A1 and name it Range1, A150 and name it Range2) and thus by latterly entering/selecting the desired name in the box above A1 (eg Range2) you can navigate to that cell directly (like a bookmark).

  4. #4
    Registered User
    Join Date
    10-23-2008
    Location
    Nigeria
    Posts
    17

    Re: bookmarks on a worksheet?

    Hello friends!

    Thank you so much for the replies.


    Dear Sweep,

    Thanks a mill, your directive works like a charm, straight to the required cell! the only limitation i have with this method is that, like all databases, my own database will not remain static; it will grow (or shrink). this means that cell references will not remain constant; i.e. State X may not always start at cell A105. Is there any way to make the cell references dynamic?
    Looking forward to hearing from you.


    Dear DonkeyOte,

    with reference to the issue i cited in my reply to Sweep (regarding dynamic cell referencing), your range reference method seems like it might do the trick, only i do not know how to execute it! I will be grateful if you could show me how to use your method.
    Eagerly awaiting your reply.

    Once again, thank you for your replies.

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: bookmarks on a worksheet?

    Quote Originally Posted by byronova
    ...i do not know how to execute it!
    re: creation of named ranges see: http://www.contextures.com/xlNames01.html

  6. #6
    Registered User
    Join Date
    10-23-2008
    Location
    Nigeria
    Posts
    17

    Re: bookmarks on a worksheet?

    Hi,

    I am implementing a solution that involves creating hyperlinks to named ranges (the range comprise the leftmost cells of the area of interest).

    Right now, this is working very satisfactorily.

    Thank you very much for all your input.

    Best wishes.

+ 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