Forum Discussion
Elisa Jenkins
Feb 21, 2018Copper Contributor
Alphabetizing worksheet names
Would appreciate any help available with this.....
I am in the process of creating a large spreadsheet of data that will contain multiple worksheets in it, all of which will have specific names. Is there any type of function to alphabetize the worksheets? Obviously it can be done manually, but I'm thinking of something similar to the auto-sort functions on the general spreadsheet.
Thanks.
EJ
- Haytham AmairahSilver Contributor
Elisa,
In fact, there is no built-in option in Excel to sort the worksheets!
But you can use some third-party add-ins or VBA solutions to do that.Please follow this link to find these solutions!
I've tried the VBA solution, and it works just fine.
- Elisa JenkinsCopper Contributor
Thank you SO MUCH! Works Perfectly!