"Worksheet Sorter" for Excel
A useful tool in PowerPoint is the "Slide Sorter" which allows you to quickly view, navigate and rearrange many slides. I think adding a "Worksheet Sorter" in Excel's "View" tab would be just as useful, and would make navigating 20+ worksheets much, much easier. If you agree with me please vote!
Worksheet sorter which shows tab colours and metadata (eg is the sheet protected, is it a worksheet or something else like a chart sheet).
Debate in my head about whether the PPT concept of "sections" is also useful here.
Not to change any references etc and not even to show up in the usual UI, purely as an organisational "grouping" construct within this sheet sorter view. Could help others working with a workbook to see which sheets are inputs, internal lookups, outputs, ready-to-print report sheets etc. And if they add a sheet they can move it to the right section to show where it fits in the business logic.
Take a look at the Sheet Navigator at www.add-ins.com
This is an excellent idea!! Could someone explain why it has only received 24 votes in more than 2 months? It seems like it would be more popular...
Thomas K commented
One fast way to change sheets are to right click in the bottom left corner where the 'left and right arrow' are.
From this 'activate' menu it is faster to change sheet.
Alban Yee commented
Is there a share button to send this out? I'd like to see this get traction too.
Bryan V commented
I'm still praying for the most basic feature, like the button that jumps you back to the first worksheet. Instead there's a useless button containing 3 little dots ( … ) . MS is struggling to get even the basic efficiency steps right.
I agree that a worksheet sorter view would be a tremendous help.
The top idea in the "Viewing / Navigating Workbooks" needed 2,581 votes for MS to take action. Please share this with your colleagues. I'm sure if we each share this a few times we can easily reach this number of votes.
Tina Somot commented
I had to write a vba script to sort the sheets. Having the ability to sort the sheets without the script can be handy.