Forum Discussion

Ktrptg713's avatar
Ktrptg713
Copper Contributor
Oct 28, 2020

Excel - Organize Tab/Sheets Alphabetically

What is the fastest way to organize the Tabs in Alpha order?  Rather than click and drag to where it goes.

Thanks.

excel
office 365

5 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Oct 28, 2020
    Mr. Hans Vogelaar solution is better, please use this ... with my suggested solution you would have to make manual changes in the code.


    Nikolino
    I know I don't know anything (Socrates)
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Oct 28, 2020

    Ktrptg713 

    Theoretically you could automate it with a VBA code, but I'm not sure if your version of Office can work with macros. As far as I've learned here, certainly not with Excel for web.
    If it does, here's the code.

     

    Sub SheetsSort ()
Dim B1 As Integer, B2 As Integer
Application.Screenupdating = False
For B1 = 1 To ThisWorkbook.Sheets.Count
For B2 = B1 To ThisWorkbook.Sheets.Count
If UCase (Sheets (B2) .Name) <UCase (Sheets (B1) .Name) Then Sheets (B2) .Move Before: = Sheets (B1)
Next B2
Next B1
Application.Screenupdating = True
End Sub

     

    Back in the table you call the macro with Alt + F8.

     

    Hope I was able to help you..and would be happy to know if I could help :).

     

    Nikolino

    I know I don't know anything (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Resources