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.
They idea has been flagged as "NOT AT THIS TIME".
But what is an alternative?
Emma Jackson commented
This post is very informative and interesting. Thank you for sharing this amazing post with us. http://bearingpk.com/
Sin Anderson commented
Please, please, please add this improvement. It is super impractical to try and deal with a row along the bottom where it's not easy to see all of the sheets. The right clicking to show a list is only temporary and is frustrating to use. I use Excel to organise just about everything and it is painful to use multiple tabs horizontally.
Please reconsider your position on this, MS. A windows XP start bar-like movable tab row, especially in complex business tools based in Excel and with MANY tabs, would be greatly aided by a vertical or two-rowed horizontal tab.
The browser version of Excel has a little hamburger menu to make the "Activate" menu more obvious and discoverable. I would like to see that added to the desktop version.
Brenner J Klenzman - they do have something like you describe in Excel - I only found out about about this in the last year or so. On the tab navigation arrows in the bottom left, right click for a drop down list where you can choose which tab to activate. If you hover over the arrows, you get a tooltip with the options. Nice!
Brenner J Klenzman commented
In addition to Excel (with lots of tabs), we also make heavy use of OneNote in our business, which can have a huge number of tabs but it provides two nice navigation methods: (1) a "..." tab with a dropdown that shows all tabs in a list, and (2) a search box. Excel could do the same thing.
G Oakley commented
I agree. Depending on the application, many tabs can be unavoidable. Excel is utilized in a vast number of industries and I do not believe Corey has experience in all of them.
What would be the alternative to having lots of tabs though? You can't combine lots of different related data sets in 1 or 2 sheets, because they are usually different columns and formats. So having multiple tabs seems like the way to accomplish it. I don't see an alternative "better design" alternative. If this is not a good design, then Microsoft needs to provide an alternative way to do it.
Corey Becker commented
I think this is probably a duplicate of this idea: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10203054-support-multi-row-worksheet-tabs-or-vertical-tabs
If you want this, I would suggest adding your vote there.
Corey Becker commented
I prefer the vertical tabs idea. I think multi-row would get messy, but I understand why some might prefer that. However, I think the Excel team is (and should be) pushing people to organize their workbooks more effectively so they use fewer tabs. You should really not be designing your workbook to have dozens of tabs. I am well aware that this is not easy in many cases, but it's best practice to limit the tabs you use in general.
This is now very much essential : Plz start Support of multi-row worksheet tabs
idbs software commented
https://www.idbssoftware.com/id-paytek -> payroll software
https://www.idbssoftware.com/id-vms -> visitor management software
https://www.idbssoftware.com/id-vms -> visitor management software in dammam
https://www.idbssoftware.com/essl-biometric-system-teltonika-gps-tracking-device -> biometric machine dealers in bangalore
https://www.idbssoftware.com/id-paytek/ -> payroll management software
I have no clue on how they kept this hidden from me. Thanks for the great tip
"You can right click the arrows to the left of the worksheet names and you can select from the window that opens what sheet you want to go to."
Yes good idea instead of writing vba wich dispaly a list
Even improving the UI of the existing right-click experience would be a good start, and take into account both touchscreen users and good old screen and mouse / keyboard warriors.
Why do we need to select a sheet in a list and then click OK? Why not jjst click to select? I suspect this is because touch screen users need to be able to push the list up and down to scroll, so that click could be misinterpreted. Some suggestions:
Show most sheets by default, eg 25, to reduce how often scroll is needed.
Enable list to be expanded to show more sheets, or possibly move to a task pane (more like the original suggestion).
Last resort, use page up / down arrows above/below the list to load more sheets rather than only relying on scroll. These could be used on touch screens but also respond to page up / down keys while this control has focus, and list should still scroll in response to scroll wheel.
Another improvement might be to show tab colours for those users who use those to extensively "colour code" sheets, eg raw input data, lookups and references, intermediate calculations, outputs in "presentation" format.
Glen Munro commented
Have you tried right clicking on the sheet tab arrows? You get a pop up of the first 15 sheets... if more than that you can go to a window that has ALL of the sheets
I create an Index sheet, with a link back to it from every sheet...
I set a reference (in Name Manager) of
The Index page looks like:
B1 "Sheet (Linked)"
and fill down the formulas...
This would be a fantastic feature, especially if it could be turned on/off, protected/unprotected, formatted, customizable and have a modern, clean, professional look.
I create left navigation bars after getting inspiration from the video below, but updates are very time consuming.
Gareth Hayter commented
Take a look at the FormulaDesk Navigator add-in. It has exactly this. https://www.formuladesk.com/formuladesk-navigator/