Alphabetically sort sheets/worksheets in a workbook
When working with large data sets, I often ended up with 50+ sheets of data, and each sheet was named by a given convention. To my knowledge, there isn't a way to sort them alphanumerically without a macro. Giving the user the ability to sort so that a1 is first then a2,b1,b2,etc rather than having to sort by hand or use a macro would be seriously amazing.
Thank you for suggesting this. We do think there is value in this idea, but we don’t think that we’ll be able to devote time to it in the near future. When our plans are updated we will re-open voting and you will be notified.
Excel Program Manager
This can be done with a UDF in a standard module - a couple of the more straight forward examples are linked below. I upvoted this idea anyway, as it should be a built-in feature. EDIT: voting is closed??? no, no, no, this is not how uservoice is supposed to work... there is no MUTE button on uservoice!
Bryon Smedley commented
I have been teaching Excel for 20+ years, and this feature has been requested by students and clients since Day 1. The solution is always macro-based. This seems like such a simple addition. Am I missing something as to why this ability does not exist?
Kenneth Barber commented
Just watch out that your 3D references (if you have any) don't break due to sheet sorting.