Tabs in Excel?


Whilst I have a consumer 365 subscription (purchased for the 1TB storage) I’ve been using Softmaker office for the past few years. The one thing I really like about Softmaker (latest version) is the tab feature in its spreadsheet package called PlanMaker. This is like google sheets where you can have a number of different files open at once and they are displayed as tabs under the top menu bar so it’s very easy to switch files. I’m trying to get to grips with excel and the only way I can do this is to go to View>switch windows, which isn’t as convenient. Does excel support tabs and if so how do I turn it on?

Comments (16)

16 responses to “Tabs in Excel?”

  1. Chris_Kez

    Assuming you're using Windows, then Stardock's program Groupy is $5 and does this for not just Excel but other software, including Windows File Explorer:

    Then again, on Windows you can set the Taskbar so that as you open new Excel files they appear as separate, labeled icons on the taskbar (at least until you have too many things open, at which point they're collapsed). I find it just as easy to hit the taskbar on bottom as it is to hit tabs on top, but everyone has preferences. Good luck, and let us know how it goes!

    • Dave

      Thanks I'll certainly look into stardock and the taskbar settings. I've got stuck in a bit of a rut having used Google sheets and softmaker products for a number of years. I'm trying to shake off my reliance on Google and move most of my work (and life!) over to Microsoft. MS makes great products and I think they respect my privacy more than Google.

    • Dave

      I've finally settled on Groupy - it's inexpensive (£4.99 in UK) and does the job perrfectly. MMettin kindly recommended office tab but the price was prohibitive. Groupy is also better than using my taskbar as it's already cluttered with many pinned icons. Thanks Chris.

  2. boots

    I know it's not the same thing, but you could change the "Combine taskbar buttons" in your Taskbar setting to "Never". This will show all of your open Excel files side-by-side on your Taskbar. They will work the same way as a tab bar.

  3. BigM72

    How much does the UI help really? You can alt-tab or win-tab using the keyboard and "real Excel users" don't use a mouse ;)

    • Dave

      I'll hold my hands up to this one. I've got lazy and really do need to wean myself off my reliance on the mouse!

    • hrlngrv

      In reply to BigM72:

      "real Excel users" don't use a mouse

      Or silly [Alt]+[Tab] or [Win]+[Tab].

      We use [Ctrl]+[F6] with or without [Shift] as we've been using since the late 1980s. Real Excel users also don't care for the SDI which came with Excel in Office 2013. Finally, real Excel users who have accepted the ribbon UI isn't going away have added the Switch Windows menu to the QAT to switch windows with a mouse more easily than hunting for it in ribbon tabs.

      Less sarcastically, I figure you can tell a REAL EXCEL USER by how much is in their QAT, and whether 90% of their ribbon usage is just in the Page Layout tab because everything else they do access through the keyboard or the QAT.

  4. madthinus

    Excel's sheet management is truly terrible.

  5. mmettin

    I use a paid option to do just that.

    It's called office tab.

    I'd link it here, but don't want to appear as a spammer.

Leave a Reply