ScubaJenn

Q: Move sheets from top of Numbers to side

In the latest version of Numbers, all the sheets I have in a spreadsheet are listed across the top.  This means I can no longer see all the sheets at a glance, but instead have to scroll through to try to find the one I need.

 

Is there a way to have them listed down the side they way they used to be?

 

It's a little thing, but it keeps me from being able to quickly switch between sheets.

MacBook Pro (15-inch Late 2011), OS X El Capitan (10.11.1)

Posted on Nov 21, 2015 12:10 PM

Close

Q: Move sheets from top of Numbers to side

  • All replies
  • Helpful answers

  • by SGIII,

    SGIII SGIII Nov 21, 2015 3:32 PM in response to ScubaJenn
    Level 6 (10,782 points)
    Mac OS X
    Nov 21, 2015 3:32 PM in response to ScubaJenn
    Hi ScubaJenn,

    Note that you can switch rapidly between sheets by swiping or dragging in the bar with the tabs (sheet names) rather than using the left-right controls on the right.

    If I have a lot of sheets and I need a vertical listing I use this Jump to Sheet Automator Service (Dropbox download). It contains a very simple AppleScript. When I hit a keyboard shortcut (I use shift-command-j) I immediately get a vertical list of all the sheets in the document, like this:
    Screen Shot 2015-07-14 at 17.20.20.png
    To install, simply double-click the downloaded .workflow package and, if necessary, click 'Install Anyway' in System Preferences > Security & Privacy. It will immediately appear in your Numbers > Services menu.  To assign a keyboard shortcut go to System Preferences > Keyboard > Shortcuts >
    Services.
    Screen Shot 2015-07-14 at 17.24.28.png

    With the rapid horizontal dragging on the "band" with the tabs and this handy Service you'll have the best of both worlds, even more convenient than the old Numbers 2 interface.

    SG
  • by Mos quito,

    Mos quito Mos quito Sep 20, 2016 7:50 PM in response to SGIII
    Level 1 (4 points)
    iPhone
    Sep 20, 2016 7:50 PM in response to SGIII

    Thank you... have been wanting to do this since day 1 of the new look. Hate the top bar, it is so inconvenient. This fix is good but it would be better if Apple would just let you choose the layout!

    Thanks!