Forum Discussion

Elisa Jenkins's avatar
Elisa Jenkins
Copper Contributor
Feb 21, 2018

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 Amairah's avatar
    Haytham Amairah
    Silver 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.

Resources