Apple Vision Pro is now available in the U.S.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Moving from one sheet to another in a Numbers document

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)

Posted on Jan 22, 2019 11:26 AM

Reply
Question marked as Best reply

Posted on Jan 23, 2019 1:23 AM

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

Similar questions

6 replies
Question marked as Best reply

Jan 23, 2019 1:23 AM in response to NMC-indy

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

Moving from one sheet to another in a Numbers document

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.