I am working in a spreadsheet that has many sheets. I have to toggle between sheets quite often and the header cannot show all of the names at once which means a lot of pressing arrows and such. I am wondering, if like the doc on a mac, you can reconfigure this. I was hoping to stack them vertically on the side of the screen which would give me quite a few sheets indeed.
Thanks in advance.
MacBook Pro with Retina display, OS X El Capitan (10.11.2)
That would be nice, just like it used to be in Numbers '09. This was one of our complaints when Apple moved the Sheets to the top as tabs versus listed down the side like they had been in prior versions. It is also one of the complaints I have always had about Excel. I had a few spreadsheets that were just like you are describing.
You can scroll through the sheets to the right using CMD+Shift+}
and to the left using CMD+Shift+{
You can go to first sheet with Option+Shift+Command+{
and to the last with Option+Shift+Command+}
Those might help
These commands are in the Window menu of Numbers. If you use them a lot and want to make them simpler, you can make simpler keyboard shortcuts for them in System Preferences, maybe overwriting the shortcuts for some other features you don't use very often. Maybe you will want to overwrite CMD+Right Arrow and CMD+Left Arrow to scroll through the sheets instead of jumping to first/last column in a table?
That would be nice, just like it used to be in Numbers '09. This was one of our complaints when Apple moved the Sheets to the top as tabs versus listed down the side like they had been in prior versions. It is also one of the complaints I have always had about Excel. I had a few spreadsheets that were just like you are describing.
You can scroll through the sheets to the right using CMD+Shift+}
and to the left using CMD+Shift+{
You can go to first sheet with Option+Shift+Command+{
and to the last with Option+Shift+Command+}
Those might help
These commands are in the Window menu of Numbers. If you use them a lot and want to make them simpler, you can make simpler keyboard shortcuts for them in System Preferences, maybe overwriting the shortcuts for some other features you don't use very often. Maybe you will want to overwrite CMD+Right Arrow and CMD+Left Arrow to scroll through the sheets instead of jumping to first/last column in a table?
I use this Jump to Sheet Automator Service (Dropbox download). You can assign it to a keyboard shortcut and it will list all your sheets and you just pick the one you want to jump to.
To install just double-click the downloaded .workflow package and if necessary give permission at System Preferences > Security & Privacy. Also make sure Automator.app is listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.
Thereafter the service will be available in the Numbers > Services menu. You can attach a keyboard shortcut to it at System Preferences > Keyboard > Shortcuts > Services.
SG
Very cool. Thanks SGIII.
For others, it is not hard to install this. The window that contains the sheet selection names will come down in the middle of the main window and once you double click the sheet you want it will disappear and you will have to summon it again. would be awesome if you could pin it to the side 😀
Thanks Badunit.
Very concise and thanks for the shortcut and hacks!
Too Many sheets in header...
