Benches Uncategorized

6

Moving from one sheet to another in a Num…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I may want to create a spreadsheet document that could potentially have many sheet tabs. Is there a better way to move between sheets rather than clicking or click-holding the left/right arrows in the tabs area? Is there a drop down menu option that would allow me to quickly select the sheet that I want to jump to?

6 replies

Sign in or join Beachball Help to reply.

  1. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You can place your cursor in the band with the "tabs" at the top and, if you have a trackpad, swipe left or right with two fingers. That is much faster than clicking the arrows.

    You can also use this Jump to Sheet Automator Service (Dropbox download). After you hit a keyboard shortcut (I use shift-command-j) it will give you a clickable vertical list of sheet names. To install it (takes less than a minute) double-click the downloaded .workflow package and if necessary give permission at System Preferences > Security & Privacy. Also make sure Automator.app and Numbers.app are listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.

    'Jump to Sheet' will now be a choice in the Numbers > Services menu. To assign a keyboard shortcut go to System Preferences > Keyboard > Shortcuts > Services and give it one.

    Remember the in Numbers you can easily have many tables on a single sheet. So you really shouldn't have to have a large number of different sheets. But if you do have more than a handful of sheets either of, or a combination of, these two approaches can help your navigation.

    SG

  2. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Well, I hope you try it.😀 That takes about a minute or two, less than the time it took you to post here.

    With the way Numbers is designed there should seldom be a need to navigate to lots of different sheets. I'm guessing that's the reason it's not programmed in.

    SG

  3. 0

    NMC-indy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks. I may try that. Too bad they don't program that in, huh?

  4. 0

    NMC-indy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Is there a link? I don't think I'm seeing one or URL to go to the Dropbox. Thanks.

  5. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Link here. (I seem to be having trouble with the new forum software).

    SG

  6. 0

    NMC-indy

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Cool! It's working. Very helpful.