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)
Thank you for taking your time to suggest and vote for this. We do think that this suggestion has merit, but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it so we know how it ranks among the other suggestions.
Jeffrey Benny commented
It's unfortunate that Microsoft cannot fulfill this suggestion considering the many votes on this idea and multiple similar ideas posted. I have set up related separate workbooks that I would combine if this function was available.
After following this post for several years, I am saddened to see MS has ignored our cries. However, there could be something better. I just began a new post: "Worksheet Sorter" for Excel. Similar to PPT's "Slide Sorter", a "Worksheet Sorter" would allow you to visually navigate through 20+ worksheets. If you agree, please go to the other post and add your support!
YES! This would make life SO much easier!
This would be a huge help for navigation purposes.
I had an excel file with 20+ tabs (not to mention another 10 that were hidden). Had to color code them so I could show which tabs were grouped together in likeness.
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.
David Sohl commented
This function would be great! It would permit combining multiple workbooks into on file.
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?
Marco van der Plas commented
This would indeed be super useful!
Andy Cox commented
This would be super useful!
I support this. It could be a 'draggable' height, like the formula box.
This feature would be a big help for me right now
Dee Cer commented
An index sheet is better nothing, but nested tabs allowing for hierarchical access would be way better.
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.