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?
MacBook (Starting Late 2009)
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
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
Cool! It's working. Very helpful.
Thanks. I may try that. Too bad they don't program that in, huh?
Is there a link? I don't think I'm seeing one or URL to go to the Dropbox. Thanks.
Moving from one sheet to another in a Numbers document
