Global Hiccup

Q: linking sheets

I have a very simple spreadsheet/database in Numbers. There are several sheets for various geograpgic regions. There is one sheet at the front that I would like to contain links that take the user to a regional sheet....bit like a hyperlink. How is this possible?

Mac mini, OS X Mavericks (10.9.1)

Posted on May 6, 2014 5:07 AM

Close

Q: linking sheets

  • All replies
  • Helpful answers

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 May 6, 2014 6:19 AM in response to Global Hiccup
    Level 7 (30,001 points)
    May 6, 2014 6:19 AM in response to Global Hiccup

    There is no "jump to" type link in Numbers. If you name your Sheets and Tables in a recognizable way, you can use the tabs to efficiently navigate to other sheets and tables. The Sheet Tab submenu has a list of tables on that sheet, and they act like links.

     

    Jerry

  • by SGIII,

    SGIII SGIII May 6, 2014 2:34 PM in response to Global Hiccup
    Level 6 (10,730 points)
    Mac OS X
    May 6, 2014 2:34 PM in response to Global Hiccup

    If you are talking about sheets within the same document, you can have something like this pop up whenever you hit a keyboard shortcut (in my case shift-command-j):

     

    Screen Shot 2014-05-06 at 5.17.41 PM.png

     

     

    This is done via a Jump to Sheet Automator Service (Dropbox download).  To install just doubleclick the .workflow package and (if needed) click 'Download Anyway' in System Preferences > Privacy & Security.

     

    This will cause a new item to appear in your Numbers > Services menu.  Then, if you want a keyboard shortcut, go here in System Preferences and add one:

     

     

    service-shortcut-add-jump-to-sheet.png

     

    You can rename or remove the service by holding down the option key in Finder and choosing Go > Library > Services. You can also view the AppleScript contaned within the service by opening the .workflow package in Automator.

     

    This particular service jumps to the first cell of the first table of the sheet you choose from an automatically generated list of all sheets in the current document. Using simple AppleScripts it is also quite easy to "jump" to any cell in the current document, to cells in other Numbers documents, or even to non-Numbers files on your Mac.

     

    SG

  • by BryantGreer,

    BryantGreer BryantGreer Nov 9, 2015 8:48 AM in response to SGIII
    Level 1 (0 points)
    Nov 9, 2015 8:48 AM in response to SGIII

    This was great! Thank you very much!

  • by SGIII,

    SGIII SGIII Nov 9, 2015 9:17 AM in response to BryantGreer
    Level 6 (10,730 points)
    Mac OS X
    Nov 9, 2015 9:17 AM in response to BryantGreer

    Glad to hear you are finding it useful!

     

    SG

  • by aaron1549,

    aaron1549 aaron1549 Sep 15, 2016 7:19 PM in response to SGIII
    Level 1 (4 points)
    Sep 15, 2016 7:19 PM in response to SGIII

    hey there

     

    no matter what i do i can not get the key board short cut to work any advice? thanks

  • by SGIII,

    SGIII SGIII Sep 15, 2016 7:30 PM in response to aaron1549
    Level 6 (10,730 points)
    Mac OS X
    Sep 15, 2016 7:30 PM in response to aaron1549

    My advice would be to be more specific about what you have tried.  Make sure the shortcut you have chosen isn't "already taken."

     

    SG

  • by aaron1549,

    aaron1549 aaron1549 Sep 16, 2016 11:35 AM in response to SGIII
    Level 1 (4 points)
    Sep 16, 2016 11:35 AM in response to SGIII

    i have tried different shortcuts indulging the one that you have listed above and currently i have it set at command j.  i see the jump to sheet in my number services but when i hit the shortcut it dose not do any thing.

  • by SGIII,

    SGIII SGIII Sep 16, 2016 11:46 AM in response to aaron1549
    Level 6 (10,730 points)
    Mac OS X
    Sep 16, 2016 11:46 AM in response to aaron1549

    Perhaps you have never used Automator on that machine before? You could double-check to make sure that 'Automator.app' is enabled (the check mark is checked) at System Preferences > Security & Privacy > Privacy > Accessibility. 

     

    SG