Support multi-row worksheet tabs, or vertical tabs, or font size (some way to see more sheet tabs at a time)
(2015-11-05 Dan [MS] - recategorized and clarified idea title)
Thanks to everyone who commented on this topic. This is certainly an idea that we’ll consider, but in the meantime, I wanted to mention that if you can’t see all the sheet tabs, you can right-click on the navigation arrows to bring up the “Activate” dialog, which gives a scrollable list of the sheets, so you can select the one you want and navigate to it. I know it’s not exactly what’s being suggested.
As with other ideas, we’ll look to see how many people vote on this, so vote for it if this is an area you want to see improved.
Steve (MS Excel)
This would be a huge improvement, very helpful.
There are lot of great comments and I would just like to add that if there is to be a navigation pane, each defined table should be selectable in it.
Also, I would have hoped the Excel Team had already implemented something after this many years.
Ooops, Re: FormulaDesk,
Just noted two things,
There is a 14 day trial available, and,
There does not appear to be a Mac Excel 2016 version.
The FormulaDesk product looks very promising, lots of good stuff. I am however put off a bit by the price, after the Beta with its 50% discount, it will be $100 annually, unless of course you want to purchase a current version and not participate in later updates. Hopefully the price will moderate a bit, as, the investment to participate in a beta as well as the gamble on the product actually solving the problem as well as hoped, as noted, is a bit daunting.
Gareth Hayter commented
I've created an Excel add-in which adds multi-row tabs among other things, which might prove useful until Microsoft adds the feature. FormulaDesk Navigator is still in beta, but you can try it here: https://www.formuladesk.com/formuladesk-navigator Is anything missing?
YES please. I've been waiting for this feature for literally years.
Eric Jardin commented
I was the "anonymous" who originally shared this idea back on October 14, 2015. I just wanted to say that over the last 3 years I have appreciated the email I would get when someone commented on this idea and shared my frustrations over tab organization. Thank you to everyone who has 'up-voted' this issue and refined the potential for solutions. I do remain shocked that this functionality hasn't received a larger response from Microsoft's Excel Team though since this is one of the most basic and used organizational tools in Excel, in my opinion.
Excel already has outline grouping within each worksheet. There could easily be a left pane for outline grouping of the tabs. I mean come on, VBA already has this outline. Why can't it be included in the spreadsheet view?!?! All of the suggestion in this thread can easily be included as a "Tab" section under "View". THIS IS NOT HARD. Thank you Matthew for getting at least some response. I would encourage you to harass them for status reports. My customers do it all the time!
Hunter Pritchett commented
Honestly, just the ability to increase the size of the "Activate" dialog that comes up when you right click the navigation arrows would be a huge improvement (of course this is only helpful if you can permanently resize this box and not have to resize it every time you open it).
Brian V commented
It is imperative this is improved, please.
The little button that skips back to the first worksheet is missing!
There are 3 little dots on a button instead that do the same as the back arrow, which is redundant. Something isn't right with that like some kind of oversight.
Thanks for responding.
I think it's safe to say no one's listening...
I agree. Multiple rows would be nice but grouping tabs would be better. I would add that having a tab tree on the left would be EXTREMELY useful and easy to implement by Microsoft. So many people are reading and responding to this thread except "Steve" from the "Excel Team" back in Jan 2016. Nearly three years ago!!! Can we get some feedback please? If you're listening please respond. If you're listening and ignoring us, then shame on you. If there's no response then nobody's listening and we all need to find a different avenue. Is there a different way to reach the "Excel Team"? Is this something that can be developed as an add-in? Who can rig this to make it 1,000,000 votes? Maybe that will get their attention.
I'm surprised there is no way to do this natively. Increasing the available UI space shouldn't be a huge chore. But if you ever address this, it would also be nice to have the ability to group tabs and display tab-groups there as well (maybe with a different shape or texture). For example, the first click on the tab opens a vertical list of its sub-tabs, and a second click opens the sub-tab selected.
Would greatly appreciate two-row or three-row tab support as soon as possible.
Yes, multi-row worksheet tabs would be very beneficial. Please consider.
L Brown commented
A dockable vertical list of worksheet tabs would be wonderful. Something similar to the OneNote interface. The activate dialog is almost just as cumbersome as scrolling horizontally through tabs. It's not very convenient for quickly switching back and forth between tabs.
Allow the Right Click Activate List to be a dockable page or a floating page so it can be maintained allowing users to go between tabs quickly. I would also suggest that you allow the tabs to be ordered in the list by drag and drop.
Maybe you could implement a "TAB INDEX" sheet as a standard - an (uneditable) sheet at the beginning of the workbook that lists all tabs and has links to them. Many use VBA to build such sheets but this would be a nice standard feature - maybe as a default if a workbook has/gets more than 5 sheets.
Russ Raine commented
This seems like a simple fix to add additional rows of tabs that could be expanded, contracted like the formula bar. Please MS, there are 250 people here who are asking, but who likely represent almost everyone who uses Excel. How much programming would it take? Excel is likely the most used analytical product in the world. Make it better for the millions of users, from noobies to experts who suffer from tab fatigue daily.
It would be great to have the option to list worksheet tabs vertically down the side of the excel window rather than multiple rows down the bottom too.