List sheet names vertically in a scrolling list sidepanel
The current way of navigating sheets is extremely slow and strenous and should be obsoleted and replaced with a vertically scrollable list sidepanel without the need of 3rd party add-ins.
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/
Look at how you select gear in video games:
Pres something to open a (radial)menu or list, hover your mouse over the item you need and let loose.
Pres and hold the "select sheet" button to open a drop-down list with all the sheets. Let the mouse loose when the desired sheet is highlighted.
Add a filter to sort alphabetically, most/last used and the same order as the sheets are. Hover your mouse over the filter button once to select the filter and hover you mouse over it again to revert the filter.
1. point arrow.
2. right click.
3. point sheet name.
4. left click.
5. point OK.
6. left click.
It's a lot of steps and only shows 20 sheets.
And can't even keep it on display all the time.
(Sheet list I want can show always.)
1. point sheet name.
2. left click.
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. I use it a lot, its much easier than scrolling from right to left all the time.