Excel - Organize Tab/Sheets Alphabetically

%3CLINGO-SUB%20id%3D%22lingo-sub-1829466%22%20slang%3D%22en-US%22%3EExcel%20-%20Organize%20Tab%2FSheets%20Alphabetically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829466%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20fastest%20way%20to%20organize%20the%20Tabs%20in%20Alpha%20order%3F%26nbsp%3B%20Rather%20than%20click%20and%20drag%20to%20where%20it%20goes.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1829466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1829544%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20-%20Organize%20Tab%2FSheets%20Alphabetically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829544%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849475%22%20target%3D%22_blank%22%3E%40Ktrptg713%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ETheoretically%20you%20could%20automate%20it%20with%20a%20VBA%20code%2C%20but%20I'm%20not%20sure%20if%20your%20version%20of%20Office%20can%20work%20with%20macros.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EAs%20far%20as%20I've%20learned%20here%2C%20certainly%20not%20with%20Excel%20for%20web.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIf%20it%20does%2C%20here's%20the%20code.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20SheetsSort%20()%0ADim%20B1%20As%20Integer%2C%20B2%20As%20Integer%0AApplication.Screenupdating%20%3D%20False%0AFor%20B1%20%3D%201%20To%20ThisWorkbook.Sheets.Count%0AFor%20B2%20%3D%20B1%20To%20ThisWorkbook.Sheets.Count%0AIf%20UCase%20(Sheets%20(B2)%20.Name)%20%3CUCASE%3E%3C%2FUCASE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EBack%20in%20the%20table%20you%20call%20the%20macro%20with%20Alt%20%2B%20F8.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you..%20and%20would%20be%20happy%20to%20know%20if%20I%20could%20help%20%3A).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1829545%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Organize%20Tab%2FSheets%20Alphabetically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849475%22%20target%3D%22_blank%22%3E%40Ktrptg713%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20for%20example%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fexcel%2Fconcepts%2Fworkbooks-and-worksheets%2Fsort-worksheets-alphanumerically-by-name%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESort%20Worksheets%20Alphanumerically%20by%20Name%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1829629%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20-%20Organize%20Tab%2FSheets%20Alphabetically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1829629%22%20slang%3D%22de-DE%22%3EMr.%20Hans%20Vogelaar%20solution%20is%20better%2C%20please%20use%20this%20...%20with%20my%20suggested%20solution%20you%20would%20have%20to%20make%20manual%20changes%20in%20the%20code.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

Thanks.

5 Replies
Highlighted

@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.

Highlighted
Highlighted
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)
Highlighted
Highlighted
Thank You!